各位大神請教一個問題。
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
只有磁區表報錯匯入失敗，單表都可以匯入資料。希望各位大神救救孩子！！！！！！
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/62382.html
標籤：DB2