Following a CA Fast Load execution with INPUT-FORMAT UNLOAD, a SELECT against the table is returning a S0C7 abend.

Document ID : KB000045779
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Execution of a SELECT statement against a table loaded with CA Fast Load for DB2 for z/OS (PFL) using INPUT-FORMAT UNLOAD syntax results in a S0C7 abend:

RUN  PROGRAM(DSNTEP4) PLAN(DSNTP410) LIB('xxxx.RUNLIB.LOAD')
IKJ56641I DSN      ENDED DUE TO ERROR+                           
IKJ56641I SYSTEM ABEND CODE 0C7   REASON CODE 00000000 

 

Cause:

The PFL job returned the following warning message:

PFL0092W - The input data is not the same version as the table version.

The input data is not the same version as the table version  
                                                             
Reason:                                                      
                                                             
The user has run a FASTLOAD job with INPUT-FORMAT UNLOAD specified, and the version number of the input data is different from the version of the target table. The load proceeds normally.                                           
                                                             
Action:                                                      
                                                             
It is up to the user to determine whether this is a problem.  For example, the user may be unloading data from one table and loading it into a different table. If the two tables have different version numbers but identical table definitions, this warning message can be ignored.  

 

Resolution:

The source and target table column order was not the same.

For the CA Fast Unload for DB2 for z/OS (PFU) OUTPUT-FORMAT LOAD / CA Fast Load for DB2 for z/OS (PFL) INPUT-FORMAT UNLOAD combination to function successfully, the table definitions between the source and target tables must match identically in terms of column definitions and column order.

Recommendation would be to use CA Fast Unload OUTPUT-FORMAT VARIABLE or OUTPUT-FORMAT DSNTIAUL in combination with CA Fast Load INPUT-FORMAT SEQ which is much more forgiving for table structure differences.