PM00051: INSERT TO BLOB SQL FAILED WITH SQLCODE904 RC00C9000A AFTER FAILING TO OBTAIN CONDITIONAL PAGE PLOCK FOR LLSMAP PAGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INSERT to BLOB sql failed with SQLCODE904 00C9000A 00C20023
  after failing to obtain conditional page plock for LLSmap page.
  DB2 needed to get header page for serialization in extention
  after the conditional plock failure, but also failed to get the
  header page because DB2 had residual BB flag and tried to get
  the header page with conditional latch.
  

Local fix

• ADDITIONAL SYMPTON:
  RC00000000 00000000
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of LOB table space    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Inserting of LOB SQL failed with        *
  *                      SQLCODE904 RC00C9000A                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Inserting of LOB failed with sqlcode904 rc00c9000a rc00c20023
  due to failure of conditional latch on the header page.
  DB2 gets header page for serialization during the extension
  of Low Level Space Map page. However, the residual value of the
  conditional latch flag in the buffer control block(BB)
  caused header page was obtained conditionally instead of
  unconditionally.  The SQL code -904 is issued due to failure
  of conditional get page of the header page.
  

Problem conclusion

• Fixed the logic to always get header page unconditionally.
  

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:

  UK53074 UK53075

Modules/Macros

• DSNOALLO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK53074

     UP10/01/20 P F001

• R910 PSY UK53075

     UP10/01/20 P F001

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.