PFU0221E HEADER PAGE error found SEGSIZE 32 EXPECTED 0 unloading from image copy.

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

Description:

Executing CA 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.

Solution:

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.