Summary:
A CA Fast Recover for DB2 for z/OS (PFR) RECOVER TABLESPACE ... OBIDXLAT execution found the following inconsistency error messages.
PFR0386E - DATA IS INCONSISTENT WITH THE DEFINITION
OF TABLESPACE ...
OBJECT TYPES DO NOT MATCH
This Error has Occurred in CSECT - FRA@OBID
PFR0389E - IDENTIFIER TARGET OBJECT SOURCE IMAGE COPY
SSID DBT1 DB2U
DBID 020C 020C
OBID 0001 0001
PSID 0002 0002
PFR0388E - ATTRIBUTE TARGET OBJECT SOURCE IMAGE COPY
TYPE SEGMENTED SEGMENTED
PAGE SIZE 10 10
SEGSIZE 0020 0020
TOTAL PARTS 0000 0000
ROW FORMAT BRF BRF
DATASET SIZE 2G 1G
# OF COLUMNS 0161 0160
The DDL between the source and the target was exactly the same with same data set size and number of columns.
Instructions:
Problem was the source table was modified to add a column via ALTER TABLE ADD COLUMN and a reorg was pending to be run.
On the source the following was run:
- ALTER TABLE ADD COLUMN...
- Created image copy without reorg being executed against tablespace.
The number of columns in the header page of the source tablespace is not updated until a reorg is run so in the header of the image copy there was a value of 0160.
And on the target the following was run:
- Created table with the added column in original definition of object (No ALTER TABLE ADD COLUMN).
- RECOVER TABLESPACE ... OBIDXLAT using image copy from source above.
The DDL was correct and in the header page of the target tablespace there was a value of 0161. PFR checked values in the header pages and failed.
A reorg must be run against the source tablespace to update the header page and remove the AREO* status set after the column was added. Then create the image copy of source tablespace to be used by RECOVER TABLESPACE ... OBIDXLAT in the target environment.