Technical Blog Post
Abstract
Load command fails with warnings SQL3550W and records rejected
Body
The table is defined as follows, which has a row change timestamp column defined:
CREATE TABLE TAB1 ( C1 int, RCT TIMESTAMP NOT NULL
GENERATED ALWAYS
FOR EACH ROW ON UPDATE AS
ROW CHANGE TIMESTAMP);
And following load command is issued to load data into the table
$ db2 load from tab1.out of del replace into tab1
...
SQL3550W The field value in row "F1-1" and column "2" is not NULL, but the
target column has been defined as GENERATED ALWAYS.
SQL3185W The previous error occurred while processing data from row "F1-1" of
the input file.
...
SQL3107W At least one warning message was encountered during LOAD processing.
Number of rows read = 1000
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 1000
Number of rows deleted = 0
Number of rows committed = 1000
The problem is caused by the row change timestamp column type. Use the following to option
to either preserve the row change timestamp values or assign new values at loading.
db2 load from tab1.out of del modified by rowchangetimestampoverride replace into tab1
db2 load from tab1.out of del modified by rowchangetimestampignore replace into tab1
UID
ibm11140304