Following Fast Load execution with INPUT-FORMAT UNLOAD SELECT against the table is returning a S0C7 abend.
Article ID: 45779
Updated On:
Products
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.
Feedback
