IBM Support What's New?

PM76272: ABEND04E RC00C90101 DSNGEPUF 501A DUE TO A CORRUPTED DBD

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00C90101 DSNGEPUF ERQUAL501A happened because a DBD
    was corrupted. The ABEND happened because a record OBD had an
    incorrect clone OBD.
    
    The incorrect clone OBD was generated because the offset x'20'
    of the base record OBD was overlaid by x'00000000_00000001'
    first. The first overlay was done by CREATE INDEX.
    
    Additional Symptoms:
    ABEND04E RC00C90101 DSNISRTI 5014 on INSERT to an old table.
    ABEND04E RC00C90101 DSNICOFS 5008 with an old format record OBD.
    ABEND04E RC00C90101 DSNKINSB 5008
    DSNICMT2 500D
    DSNITCUS 5002
    DSNILGCL 5004
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users who create index on a table    *
    *                 or insert rows to a table which was          *
    *                 created prior to z/OS, V5.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: There could be the following problems   *
    *                      with the table created prior to z/OS,   *
    *                      V5,                                     *
    *                                                              *
    *                      1.  After creating an index on the      *
    *                      table, any access to the DBD may cause  *
    *                      an ABEND04E in DSNGEPUF ERQUAL501A      *
    *                      because the DBD was corrupted.          *
    *                                                              *
    *                      2.  When inserting a row to the table,  *
    *                      customer could receive the following    *
    *                      abends,                                 *
    *                                                              *
    *                      ABEND04E RC00C90101 DSNISRTI            *
    *                      ERQUAL5014                              *
    *                      ABEND04E RC00C90101 DSNICOFS            *
    *                      ERQUAL5008                              *
    *                      ABEND04E RC00C90101 DSNKINSB            *
    *                      ERQUAL5008                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    For a table created before z/OS, V5, one of the internal data
    structures does not exist. Create an index on such a table could
    incorrectly access this internal data structure which results
    in OBD overlay. When inserting a row to such a table, DB2 could
    incorrect access this internal data structure, which results in
    the above abends.
    

Problem conclusion

  • DB2 has been changed to avoid accessing the internal data
    structure when it does not exist.
    
    Applying this apar can fix the abends when inserting a row to
    the table but it does not fix the OBD which is already overlaid.
    Contact IBM Software Support for assistance in analyzing this
    problem.
    
    Addional keyword:SMCOVERLAY  DB2OVRLAY/K
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM76272

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-31

  • Closed date

    2013-02-25

  • Last modified date

    2015-08-31

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

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

    UK91977

Modules/Macros

  •    DSNGDBIX DSNGDDIX DSNICOFS DSNISRTI DSNKINSB
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91977

       UP13/03/13 P F303

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.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PM76272

Modified date: 2015-08-31