DSNU311I - Rows discarded in IBM load when table contains LOB columns

book

Article ID: 36832

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

Problem:

In a strategy with Unload and load of data, the LOAD from a table with LOB columns results in discarded rows and messages like this:

DSNU311I  -DBD4 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

 

....

Environment

Release:
Component: RCM