If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL3550W error code when db2move load

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-16-06, 05:49
kswaughs kswaughs is offline
Registered User
 
Join Date: Oct 2006
Posts: 2
SQL3550W error code when db2move load

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.
Reply With Quote
  #2 (permalink)  
Old 10-16-06, 13:27
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Using the same IXF files created by db2move export, you can manually load the data with the MODIFIED BY IDENTITYOVERRIDE parm for those tables that require it.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On