Prev: Can Not Create Database - DAS Is Not Active
Next: DB Backup error
From: danths on 27 Jun 2007 23:37
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.

From: Philip Nelson on 29 Jun 2007 08:21
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.

 | 
Pages: 1
Prev: Can Not Create Database - DAS Is Not Active
Next: DB Backup error