I am using DB2 "DB2 v8.1.7.445 s040812", "WR21342", and FixPak "7".
Product Name = "DB2 Universal Database Express Edition"
Product Identifier = "DB2EXP"
Version Information = "8.2"
Expiry Date = "4/8/2006 (Try & Buy)"
Registered User Policy = "Disabled"
Enforcement Policy = "Soft Stop"
Number of processors = "1"
Number of licensed processors = "2".
My O/S is Windows XP.
when loading the database from one System to Other system using db2move.
I got this error msg while using db2move dbname load.
SQL3550W The field value in row "1" and column "1" is not NULL, but the
target column has been defined as GENERATED ALWAYS.
SQL3185W The previous error occurred while processing data from row "1" of
the input file.
SQL3550W The field value in row "2" and column "1" is not NULL, but the
target column has been defined as GENERATED ALWAYS.
SQL3185W The previous error occurred while processing data from row "2" of
the input file.
My tables consists Autogenerated Columns and reference foreign keys.
I used this command for export :
db2move dbname export
db2look -d dbname -e -a -o test.sql
At the destination source, I used these cmds to import
db2 -tvf test.sql
db2move <databasename> load
I need help in moving the table data which has Foreign key references and Auto Increment columns.