CA Fast Load with INPUT-FORMAT UNLOAD returns message PTFL135 FAILED OBID CHECK in SYSMAP dataset.

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

Problem:

CA Fast Load for DB2 for z/OS (PFL) may discard all rows with the following symptoms where control card INPUT-FORMAT UNLOAD is specified:

All rows are discarded as can be seen by message:

    PFL4013I - Records DISCARDED to dataset .................####

The following can be seen in the SYSMAP dataset.

    PTFL132 - INPUT    RECORD ID    DISCARD ID    CONDITION        
    PTFL135   001              1               1             Failed OBID Check

The PFL job will end with a condition code 4 or higher and no rows are loaded to the table.

 

Resolution:

PFL INPUT-FORMAT UNLOAD is compatible with CA Fast Unload for DB2 for z/OS (PFU) where OUTPUT-FORMAT LOAD was specified during the unload. If PFU was executed with a different OUTPUT-FORMAT then use INPUT-FORMAT SEQ on the PFL execution.

The source table OBID is written into the unload file during the PFU unload process when OUTPUT-FORMAT LOAD is specified.
To ensure data integrity, PFL verifies that the OBID in the input file is the same as the target table to be loaded. If the source and target tables do not have the same OBID, then the OBID parm may be used during the PFL execution to specify the source table OBID present in the input file.

The source and target table DDL must be identical, data conversion is not allowed with INPUT-FORMAT UNLOAD.