PI77850: HEALTH CHECK BEFORE DBD IS WRITTEN OUT TO DB01 TO PREVENT BROKENDBD FROM PROPAGATING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Health check before DBD is written out to DB01 to prevent a
  corrupted DBD from propagating .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Customer may receive the following abends:                   *
  *                                                              *
  * ABEND0C4 RC00000038 at dsngedm .dsngepuf OFFSET07112         *
  * ABEND04E RC00c90101 at dsngedm .dsngedlc ERQUAL5024          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An overlaid DBD is incorrectly written out to DBD01 table.
  Subsequent loading of the DBD from DBD01 hit the above abends.
  

Problem conclusion

• DB2 has been changed to add sanity check code to prevent broken
  DBDs from being written out. After applying the apar,
  if the DBD is broken, the following abend could be received:
  
  ABEND04E RC00C90101 at DSNGD001.DSNGDCPD ERQUAL5008
  ABEND04E RC00C90101 at DSNGD001.DSNGDCPD ERQUAL500C
  ABEND04E RC00C90101 at DSNGD001.DSNGDCPD ERQUAL500B
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDRP ERQUAL5002
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDRP ERQUAL501E
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDRP ERQUAL501B
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDRP ERQUAL501F
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDRP ERQUAL500B
  
  The serviceability code is added for  the DBD which is already
  broken on DBD01,  the following abends could be received:
  
  ABEND04E RC00C90101 at DSNGEDM.DSNGEPUF ERQUAL501D
  ABEND04E RC00C90101 at DSNGEDM.DSNGEDLC ERQUAL0000
  
  Additional keyword: DB2OVRLAY/K
  

Temporary fix

Comments

APAR Information

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

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

  UI48088

Modules/Macros

• DSNGEDLC DSNGDCPD DSNGEDRP DSNGEPUF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI48088

     UP17/07/01 P F706

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.