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
    

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

    2013-04-02

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM76272

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation