Home > database >  DB2 import and export, the partition table failure, single table
DB2 import and export, the partition table failure, single table

Time:09-21

Everyone a great god ask a question,
Have business with 30 DB2 table, single table, partition table,
After export and import have to be renamed the import of 30 tables, the results of all the single table data can be imported successfully, but the partition table cannot be imported into,
Before the import already in the database, according to the original table statements, manually create new tables, and consistent enough, just name is different,

The following relevant error message when
One of the MSG file content is as follows:
[db2inst1 @ newamldb 2 edbak] $cat tab8. MSG
SQL3104N The Export utility is beginning to Export The data to The file "tab8. Ixf".

SQL27984W The export command completed successfully. An some
Information that whenever required to recreate one or more tables from the then
Saved to the output file. The file will not be able to be 2 by the IMPORT
The command to create or replace tables. Reason code: "4".

SQL3105N The Export utility has finished exporting "1" rows.

SQL3150N The H record in The PC/IXF file from The product "DB2 02.00", The date
"20190508", the time and "115542".

SQL3153N The T record in The PC/IXF file has The name "tab8. IXF", The qualifier ", "
And the source "".

SQL3311N The import operation failed because some aspect of The data in The
IXF input file is not supported with the CREATE parameter or the
CREATE_REPLACE parameter. Reason code: "4".

SQL3110N The utility has completed processing. "0" rows were read from The
The input file.

SQL3150N The H record in The PC/IXF file from The product "DB2 02.00", The date
"20190508", the time and "115542".

SQL3153N The T record in The PC/IXF file has The name "tab8. IXF", The qualifier ", "
And the source "".

SQL3311N The import operation failed because some aspect of The data in The
IXF input file is not supported with the CREATE parameter or the
CREATE_REPLACE parameter. Reason code: "4".

SQL3110N The utility has completed processing. "0" rows were read from The
The input file.



The total import. Out part of the output is as follows:
* the IMPORT: table "AML". "T3A_REPORT_HST_2ED
"* * * ERROR - 3311. Check the message file tab31. MSG!
* * * SQLCODE: - 3311 - SQLSTATE:
* * * SQL3311N The import operation failed because some aspect of The data in The IXF input file is not supported with The CREATE parameter or The CREATE_REPLACE parameter. The Reason code: "4".

* the IMPORT: table "AML". "T3A_MSG_HST_2ED
"* * * ERROR - 3311. Check the message file tab32. MSG!
* * * SQLCODE: - 3311 - SQLSTATE:
* * * SQL3311N The import operation failed because some aspect of The data in The IXF input file is not supported with The CREATE parameter or The CREATE_REPLACE parameter. The Reason code: "4".

* the IMPORT: table "AML". "T3A_RPT_CASE_HST_2ED
"* * * ERROR - 3311. Check the message file tab33. MSG!
* * * SQLCODE: - 3311 - SQLSTATE:
* * * SQL3311N The import operation failed because some aspect of The data in The IXF input file is not supported with The CREATE parameter or The CREATE_REPLACE parameter. The Reason code: "4".

* the IMPORT: table "AML". "T2A_CASE_TRANS_CUR_2ED
"- Rows read: 6506
- Inserted: 6506
- Rejected: 0
- Committed: 6506

* the IMPORT: table "AML". "T2A_CASE_CUST_CUR_2ED
"- Rows read: 1392
- Inserted: 1392
- Rejected: 0
- Committed: 1392

* the IMPORT: table "AML". "T2A_CASE_ACCT_CUR_2ED
"44 - Rows read:
44 - Inserted:
- Rejected: 0
44 - Committed:

* * Error occured - 1

Disconnecting from the database... Successful!

End time: 8 13:00:44 Wed May 2019





Only partition tabulated import failure fault, single table can import data, wish you a great god save the children!!!!!!!!!!!!!!!
  •  Tags:  
  • DB2
  • Related