PFR0386E Data is inconsistent with the definition executing Fast Recover OBIDXLAT

Products

• Fast Recover for DB2 for z/OS

Issue/Introduction

Executing Fast Recover for Db2 for z/OS (PFR) which is returning the following:

PFR0386E - DATA IS INCONSISTENT WITH THE DEFINITION
           OF TABLESPACE 'dbname.tsname' PART 0001
           OBJECT TYPES DO NOT MATCH
           This Error has Occurred in CSECT - FRA@OBID

PFR0389E - IDENTIFIER    TARGET OBJECT   SOURCE IMAGE COPY
           SSID              ssid             ssid
           DBID              0001             0001
           OBID              0002             0002
           PSID              0003             0003

PFR0388E - ATTRIBUTE     TARGET OBJECT   SOURCE IMAGE COPY
           TYPE            UTS - PBR        UTS - PBR
           PAGE SIZE         04               04
           SEGSIZE           0040             0040
           TOTAL PARTS       0035             0035
           ROW FORMAT        RRF              RRF
           DATASET SIZE        4G               4G
           # OF COLUMNS      002C             002C
           RBA FORMAT       EXTENDED          BASIC

Resolution

From the error message output it shows that the RBA Format on the source does not match that on the target.

RBA FORMAT       EXTENDED          BASIC


See message: PFR0386E

In SYSIBM.SYSTABLEPART there is an RBA_FORMAT column.

Check the tablespace in question and drill down to the SYSIBM.SYSTABLEPART rows to see what the RBA_FORMAT column is set to.........they would be set to "B" for BASIC.

If you find that the RBA_FORMAT in the SYSIBM.SYSTABLEPART is BASIC this can be converted using a REORG.

RBALRSN_CONVERSION—Convert RBA or LRSN Formats

Add

RBALRSN_CONVERSION EXTENDED

to the REORG parameters

After that a new image copy would have the EXTENDED format and would not give the error as both SOURCE and TARGET tablespaces would have the same RBA Format.