Migration from V8(solaris) to V9(redhat)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

danths - 28 Jun 2007 04:37 GMT

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.

Reply to this Message

Philip Nelson - 29 Jun 2007 13:21 GMT

Sounds like you have a permission problem on the files you are trying to
import. The group of files which are being read are the file.ixf file
where the base data is put and the files storing the LOB data.

Remember that no matter which user you issue to command from the files you
have created must be readable by the DB2 instance owner (by default
db2inst1).

Phil

> 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
[quoted text clipped - 32 lines]
>
> of the input file.

Reply to this Message