Hello: We are trying to migrate DB2 Source: DB2 8.1 + Fixed Pack 5 on
Sun Solaris -Target: DB2 9.X on Red Hat Linux . using db2move
command we are trying out the migration. However one of the tables
contains blob and clob data. What is teh correct way to move such a
table?
Here's the error we get. Any help is much appreciated.
Thanks
================================================== =========
db2 export to file.ixf of ixf lobs to /prod-backups/WCSL/
db2move_db2wcsl/tblmaildetaillobs/ lobfile lob1,lob2 modified by
lobsinfile select * from "DB2EZML.TBLMAILDETAILS"
db2 import from file.ixf of ixf lobs from /wcsl/db2wcsl/dbase/
tblmaildetaillobs/ modified by lobsinfile create into
DB2EZML.newTBLMAILDETAILS
*** Errors ***
SQL3148W A row from the input file was not inserted into the table.
SQLCODE
"-452" was returned.
SQL0452N Unable to access the file referenced by host variable "12".
Reason
code: "1". SQLSTATE=428A1
SQL3185W The previous error occurred while processing data from row
"36963"
of the input file.