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."
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!