IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PH54836

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-05-31

  • Closed date

    2023-09-12

  • Last modified date

    2024-09-23

  • 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.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 September 2024