PI87240: ABEND04E RC00C90101 DSNOLADS ERQUAL500B

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 abends at DSNOLADS:500B(could also be 500A,500C or 500D)
  when it try to UNDO the deallocation log for a lob page,
  however, on the LLSMAP, this page's allocation bit is not in the
  status of "deallocation", or says, "allocated". From the archive
  logs, we could find the log of deallocation and the
  corresponding redo log. This servicebility apar is to give
  us the info whether the redo log is done correctly.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 for z/OS users of LOB table                          *
  * space                                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00C90101 DSNOLADS                                 *
  * ERQUAL500B                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  DB2 abends at DSNOLADS:500B(could also be 500A,500C or 500D)
  when it try to UNDO the deallocation log for a lob page,
  however, on the LLSMAP, this page's allocation bit is not
  in the status of "deallocation", or says, "allocated".
  
  From analyzing the log records, there is no information
  that undo log record is actually applied.
  

Problem conclusion

• A servicebility code was added to enhance the DB2 logic
  to set CLR log record was not applied flag(LGDNAPLY) after
  log record actually procssed.
  

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:

  UI53303 UI53304

Modules/Macros

• DSNOLADS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI53303

     UP18/02/02 P F802

• RB10 PSY UI53304

     UP18/02/02 P F802

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.