[ILUG] db2 databsae backup question..

Declan Boylan decob at redbrick.dcu.ie
Thu Apr 29 16:45:44 IST 2004


Presently trying to restore my db from a nightly backup...

the restore script i have opens each of the backup tar files and then
runs the following command to import the data...

db2 "import from data.ixf of ixf modified by lobsinfile insert into  data"

now every time that is run, it comes up with the following errors

SQL3150N  The H record in the PC/IXF file has product "DB2    02.00",
date "20040429", and time "000502".

SQL3153N  The T record in the PC/IXF file has name "data.ixf", qualifier
"", and source "            ".

SQL3109N  The utility is beginning to load data from file "data.ixf".

SQL3148W  A row from the input file was not inserted into the table.
SQLCODE "-803" was returned.

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 "DB2.DATA" from having duplicate rows for those
columns. SQLSTATE=23505

SQL3185W  The previous error occurred while processing data from row "1"
of the input file.

any ideas of what i'm doing wrong, or whats wrong... as i'm not very
familiar with db2..

cheers

-- 
"They misunderestimated me."



More information about the ILUG mailing list