By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Migration from V8(solaris) to V9(redhat)

P: n/a
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.

Jun 28 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

danths wrote:
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.
Jun 29 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.