PH54836: ABEND04E 00C200F7 IN DSNB1GET OFFSET0529A RUNNING A REORG UTILITY AFTER AN ALTER FROM PBG TO PBR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C200F7 in DSNB1GET+0529A occurs running a REORG
  utility after an ALTER that changed the partitioning schema from
  PBG to PBR this is specific to the V13 PBG->PBR conversion.
  The materializing REORG failed in the UNLOAD phase due to a
  00C200F7 on a getpage of the spacemap for a source PBG partition
  due to inconsistent page number detected. The source PBG table
  space has multiple partitions, some of which has instance I and
  some has instance J  before REORG and ALTER to PBR is run. When
  the materializing REORG invokes DDL/DBDM to build the shadow OBD
  that maps to the new PBR definition, the shadow OBDPSET was
  incorrectly constructed with the same instance value for all the
  partitions resulting in various internal control block
  corruptions and led to the eventual 00C200F7 get page error when
  accessing the original. Below is an example to recreate :
  1)Create a 3 parts PBG, all start with instance = I
  2)Run a REORG against part 2. After this REORG, part 1 has
    instance I, part 2 has instance J, and part 3 has instance I
  3)Issue the ALTER to PBR of 5 partitions
  4)Run the materializing REORG. The shadow OBD constructed has
    instance I for part 1 to 5, but I expect part 2 to have
    instance J to avoid collision with the source object.
  Additional symptoms:
  ABEND04E RC00C90101 at DSNIZLDR:5002
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users of REORG that                         *
  * materializes ALTER TABLE                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 might issue ABEND04E RC00C200F7 in                       *
  * DSNB1GET OFFSET0529A while running a                         *
  * REORG utility that materializes a                            *
  * pending ALTER TABLE converting the                           *
  * partitioning scheme from partition-by-                       *
  * growth (PBG) to partition-by-range                           *
  * (PBR), and the PBG UTS contains                              *
  * partitions with different INSTANCE                           *
  * value.                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Due to Db2 internal process error, when the user attempts to
  run REORG utility to materialize a pending ALTER TABLE process
  which converts the partitioning scheme from
  partition-by-growth (PBG) to partition-by-range (PBR), if the
  PBG UTS contains partitions with different INSTANCE values
  (SYSTABLEPART.INSTANCE), Db2 might incorrectly issue ABEND04E
  with RC00C200F7 in DSNB1GET OFFSET0529A.
  As a result, the underlying table space remains PBG UTS.
  In some cases, if the ABEND04E with RC00C200F7 happens in
  (RE)LOAD phase of the REORG, there might be a subsequent
  failure for REORG with RC00C200F8 error, or ABEND04E RC00C90101
  in DSNIZLDR 5002 ERQUAL5002 The related part will need to be
  recovered manually.
  

Problem conclusion

• Db2 code has been fixed. The REORG utility completes
  successfully to materialize the pending ALTER TABLE operation
  to convert the partitioning scheme from PBG to PBR after
  applying this PTF.
  Additional keywords:
  SQLALTER
  SQLPBG
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI93543

Modules/Macros

• DSNGDAG1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI93543

     UP23/09/21 P F309

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.