IBM Support

Load command fails with warnings SQL3550W and records rejected

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
 

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140304