IBM Support

PM77066: ABEND04E RC00C90101 DSNIDBHK ERQUAL500C AFTER APPLYING PM53155 (V10 UK77362, V9 UK77364, V8 UK77363) 12/11/15 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With apar PM53155 , the following abend could occur during
    group restart:
      DSN ABND 04E 00C90101 U=SYSOPR M=(N) C=910 DMC
      DSNIDBLG M DSNTFRCV LOC DSNIDM DSNIDBHK 500C
    A portion of the DBET base SCA record(s) was accidentally
    deleted which resulted in the local DBET being built
    incorrectly.
    From the dump, for the dbet_db being processed, the lowest
    partition number was higher than the highest partition number ,
    and that highest partition number ' dbedhpnc ' was zeroes .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS data sharing users with  *
    *                 PM53155 / UK77362, DB2 9 for z/OS data       *
    *                 sharing users with PM53155 / UK77364 and     *
    *                 DB2 V8 for z/OS data sharing users with      *
    *                 PM53155 / UK77363 applied                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIDBHK ERQUAL500C *
    *                      during several data sharing members'    *
    *                      DB2 checkpoint after group restart,     *
    *                      leading to their DB2 crash with         *
    *                      MSGDSNV086E RC00D95001                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During group restart, while updating the group DBET in SCA,
    a subset of the DBET base SCA record(s) for an object was
    accidentally deleted, which resulted in local DBET entry for the
    object being built incorrectly.
    
    In this case, there were more than 200 partitions with diverse
    exception states such that the DBET entry for this object had
    multiple DBET blocks. During internal DBET rectify, at the
    beginning of forward log apply phase, the group DBET in SCA
    needed to be updated since local DBET had to reset an internal
    extend-in-progress state.
    
    However, when copying the local DBET blocks to the group DBET in
    SCA, by mistake not all the DBET blocks were copied. This
    resulted in an incomplete group DBET in SCA for this object.
    
    When other members of the data sharing group came up, their
    local DBET was built incorrectly, eventually leading to the
    aforementioned ABEND04E.
    
    The first member that performed the rectify was able to come
    up successfully because his local DBET was not corrupted. Any
    subsequent DBET updates that this member performed after the
    group restart automatically cleaned up the group DBET in SCA,
    which is why the originally failed members were able to restart
    on their second restart attempt.
    

Problem conclusion

  • DB2 code has been modified such that the group DBET in SCA is
    updated correctly during DBET rectify.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM77066

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-14

  • Closed date

    2013-01-31

  • Last modified date

    2013-03-04

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

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

    UK91321 UK91322 UK91323

Modules/Macros

  • DSNIDBNG DSNIDBNI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91321

       UP13/02/16 P F302 ®

  • R810 PSY UK91322

       UP13/02/16 P F302 ®

  • R910 PSY UK91323

       UP13/02/16 P F302 ®

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 March 2013