DB2导入导出,分区表失败,单表成功
各位大神请教一个问题。
DB2有业务有30张表,单表、分区表都有。
导出后,导入时要对30张表进行改名导入。结果所有的单表数据都能导入成功,但是分区表都不能导入进去。
再导入前已经在数据库里,根据原来的表语句,手动建立新表,也够一致,只是名字不同。
以下时相关的报错信息
其中一个MSG文件内容如下:
[db2inst1@newamldb 2edBak]$ cat tab8.msg
SQL3104N The Export utility is beginning to export data to file "tab8.ixf".
SQL27984W The export command completed successfully. However, some
information that would be required to recreate one or more tables has not been
saved to the output file. The file will not be able to be used by the IMPORT
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 has product "DB2 02.00", date
"20190508", and time "115542".
SQL3153N The T record in the PC/IXF file has name "tab8.ixf", qualifier "",
and 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
input file.
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20190508", and time "115542".
SQL3153N The T record in the PC/IXF file has name "tab8.ixf", qualifier "",
and 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
input file.
总的import.out部分输出结果如下:
* IMPORT: table "AML"."T3A_REPORT_HST_2ED"
***ERROR -3311. Check 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. Reason code: "4".
* IMPORT: table "AML"."T3A_MSG_HST_2ED"
***ERROR -3311. Check 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. Reason code: "4".
* IMPORT: table "AML"."T3A_RPT_CASE_HST_2ED"
***ERROR -3311. Check 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. Reason code: "4".
* IMPORT: table "AML"."T2A_CASE_TRANS_CUR_2ED"
-Rows read: 6506
-Inserted: 6506
-Rejected: 0
-Committed: 6506
* IMPORT: table "AML"."T2A_CASE_CUST_CUR_2ED"
-Rows read: 1392
-Inserted: 1392
-Rejected: 0
-Committed: 1392
* IMPORT: table "AML"."T2A_CASE_ACCT_CUR_2ED"
-Rows read: 44
-Inserted: 44
-Rejected: 0
-Committed: 44
**Error occured -1
Disconnecting from database ... successful!
End time: Wed May 8 13:00:44 2019
只有分区表报错导入失败,单表都可以导入数据。希望各位大神救救孩子!!!!!!