Fast Load : INPUT-FORMAT UNLOAD returns message PTFL135 FAILED OBID CHECK in SYSMAP dataset.
Article ID: 25664
Updated On:
Products
Issue/Introduction
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 .................nnnn
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 0 or higher and no rows are loaded to the table.
Environment
Release: R20
Component: PFL
Resolution
The FAST LOAD(PFL) keyword INPUT-FORMAT UNLOAD is compatible with Fast Unload (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.
Additional Information
Feedback
