PFU0221E HEADER PAGE error found SEGSIZE 32 EXPECTED 0 unloading from image copy.
Article ID: 28734
Updated On:
Products
Issue/Introduction
Executing Fast Unload for DB2 for z/OS (PFU) unloading from an image copy and unload fails with the following errors:
PFU0043I - IMAGECOPY/DSN1COPY REQUESTED - DDLDDN NOT SPECIFIED -
TABLE DEFINITION IN DB2 CATALOG WILL BE USED
PFU0221E - HEADER PAGE ERROR -> FOUND SEG SIZE : 00032 EXPECTED 00000
The attributes of the tablespace / table have changed since the image copy specified in the unload was created.
Resolution
To unload from an image copy where the DDL definition differs requires specification of the DDLDDN keyword.
Per the PFU User Guide:
--------------------------------------------------------------------------
DDLDDN Keyword Retrieve DDL from a Data Set
The DDLDDN keyword retrieves DDL information from a data set.
Use this keyword to unload data rows from an image copy that
is not current. If the table or tablespace changes after the
copy is created, the DB2 catalog definition of the table or
tablespace no longer matches the copy. The DDLDDN keyword
lets you specify the data set that contains the DDL for the
original table or tablespace.
--------------------------------------------------------------------------
1. Create a PDS member or sequential dataset with the CREATE TABLE DDL of the original table definition when the image copy was created.
2. Execute PFU using the DDLDDN keyword directed at the PDS member or sequential dataset from step 1.
Executing PFU with the DDLDDN keyword requires the OBID option to be specified. Provide the original OBID of the table if known otherwise
the SEARCH-OBIDS keyword can be specified to have the OBIDs found within the image copy to be written in the PFU message output.
Feedback
