Hello All,
I am migrating my current system from oracle/IBM to DB2/IBM .The export was successfull.
Now during the import only one package has gone into error.
Following are the details:
In the "import_state.properties" file one package is in error
***********************************************
"SAPDFACT=-"
************************************************
In the SAPDFACT.TSK file the following Table has error
***********************************************************
"D /BI0/F0SMD_CA01 I err"
***********************************************************
In the SAPDFACT.LOG follwing is the error.
***************************************************************
(DB6) LOAD API is not used for table with small buffer
(DB6) Using ARRAY INSERT for table /BI0/F0SMD_CA01
(DB6) [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement
are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "SAPSOL./BI0/F0SMD_CA01" from having duplicate val
ues for the index key. SQLSTATE=01661
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: disconnected from DB
*******************************************************************
Please suggest....