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

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

book

Article ID: 45779

calendar_today

Updated On:

Products

Fast Load for DB2 for z/OS

Issue/Introduction

Execution of a SELECT statement against a table loaded with 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 Fast Unload for DB2 for z/OS (PFU) OUTPUT-FORMAT LOAD / 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 Fast Unload OUTPUT-FORMAT VARIABLE or OUTPUT-FORMAT DSNTIAUL in combination
with Fast Load INPUT-FORMAT SEQ which is much more forgiving for table structure differences.