DSNU311I Rows discarded in IBM load when table contains LOB columns within RC/Migrator

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

In a RC/Migrator for Db2 for z/OS (RCM) strategy with unload and load of data, the load of a table with LOB columns results in discarded rows and messages like this:

DSNU311I  -ssid 007 14:13:34.67 DSNURWRF - RECORD (1) WILL BE DISCARDED DUE
TO INVALID 'PARSETREE' COLUMN SPECIFICATION

Resolution

Check that the LOAD Model have been upgraded and contains the symbolic %INFORM                                         

...

.DATA                                               

   LOAD DATA INDDN PTILOAD RESUME %RESUME LOG %LOG  

    %INFORM                                         

    %ENFORCE                                        

    %UNICODE                                         

    DISCARDDN SYSDISC    

...                            

 

When the unload generates the load control statements, it uses the new %INFORM symbolic to insert FORMAT SPANNED YES in the load syntax.
This syntax allows LOAD to load the table data.

The correct LOAD statement will look like this example:

...

DATA

LOAD DATA INDDN PTILOAD RESUME NO LOG NO

FORMAT SPANNED YES

ENFORCE CONSTRAINTS

UNICODE