PH36531: ABEND04E RC00C90101 AT DSNKINSN ERQUAL5009 AND DSNKFTIN ERQUAL5066 FOR FTB INSERT PLOCK FAILURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 abends at DSNKINSN 5009 AND DSNKFTIN 5066 due to FTB insert
  failure.
  
  The save area of dump DSNKINSN 5009 shows Db2 enter the code
  path for FTB insert Plock notify to other members in
  Data-sharing group during INSERT, but it received a notify
  failure with RC00C900FB from other member.
  
  The dump of DSNKFTIN 5066 shows the system Plock exit agent
  020.PEXENG00 failed due to invalid FTB structure which is
  for the same object in dump DSNKINSN 5009
  
  Additional symptoms: 00C900FB 00C90101 ERQUAL5009 ERQUAL5066
                       DB2FTB/K
  

Local fix

• BYPASS/CIRCUMVENTION:
  Disable the FTB function to prevent further abends.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users                                    *
  * with in-memory index optimization function                   *
  * enabled (Index Fast Traverse Block-FTB).                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When index fast traverse block(FTB)                          *
  * is in use, the following ABENDs could                        *
  * happen during the index page split.                          *
  * ABEND04E RC00C90101,                                         *
  * LOC=DSNIDM.DSNKFTIN ERQUAL5066                               *
  * ABEND04E RC00C90101,                                         *
  * LOC=DSNIDM.DSNKINSN ERQUAL5009                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When index fast traverse block(FTB) is in use, serialization
  between mass delete and FTB creation was not correctly
  maintained. In a small timing window that mass delete and
  FTB creation were executed around the same time,
  while mass delete had already modified the index
  tree structure, FTB was created using the non leaf information
  before the mass delete. The invalid entries in FTB caused
  subsequent index split to abend.
  ABEND04E RC00C90101, LOC=DSNIDM.DSNKFTIN ERQUAL5066
  ABEND04E RC00C90101, LOC=DSNIDM.DSNKINSN ERQUAL5009
  

Problem conclusion

• Db2 code has been modified to correctly serialize index FTB
  creation processing with mass delete operation.
  Additional keyword : DB2FTB/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:

  UI75391

Modules/Macros

• DSNKFTOB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI75391

     UP21/05/21 P F105 ¢

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.