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

Obtain the fix for this APAR.

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