PH25244: UNNECESSARY OVERFLOW RECORD IS CREATED FOR PAGE LEVEL LOCKING OBJECTS

APAR status

• Closed as program error.

Error description

• For page level locking objects, there're cases that update could
  create overflow records even when there's enough free space in
  the page.
  
  Additional symptoms: DSNOTCSO 53AC ERQUAL53AC 00C90D01
  DSNI013I MSGDSNI013I
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 12 for z/OS                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABND04E RC00C90D01 AT DSNOTCSO+06F46                         *
  * when the uncommitted row containing                          *
  * LOB columns was treated as the                               *
  * committed row.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  During insert searching for the space on the page, Db2
  marked the row as committed when the page was not yet
  committed. If this row contained LOB columns, any reader
  of the LOB column could encounter ABND04E RC00C90D01 AT
  DSNOTCSO+06F46 due to AUX index mismatching.
  

Problem conclusion

• Db2 has been modified to check the page's commit status
  before marking rows as committed during insert process.
  

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:

  PH46568 UI90222

Modules/Macros

• DSNIDLDU DSNIDLDS DSNIKDEF DSNIDLOD DSNIDILS DSNIREPR DSNISGRT
  DSNISMCP DSNILREP DSNISMRT DSNIDLEO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI90222

     UP23/01/31 P F301