PH21916: ABEND04E RC00C90101 IN LOC=DSNIDM DSNKFLOK 1001 DURING FAST TRAVERSAL PROCESSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 in LOC=DSNIDM .DSNKFLOK:1001 during
  Fast Traversal processing
  Additional Keyword: ZSA2 DB2FTB/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 V12 for z/OS users with in-memory                    *
  * index optimization function switched on                      *
  * (Index Fast Traverse Block - FTB)                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00C90101 DSNIDM.DSNKFLOK                          *
  * ERQUAL1001                                                   *
  * ABEND04E RC00C90101 DSNIDM.DSNKFEXT                          *
  * ERQUAL5002                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The ABEND04E RC00C90101 DSNIDM.DSNKFLOK ERQUAL1001 occurred
  when acquiring a FTB P-lock in data sharing because this FTB
  P-lock was already held on this Db2 member by another owning
  work unit.   Earlier, when the index was closed, Db2 missed
  freeing the FTB P-lock.  This caused the ABEND after the index
  was reopened, and a FTB P-lock was requested.
  The FTB P-lock, that wasn't freed when the index was
  closed, could also cause an ABEND04E RC00C90101
  DSNIDM.DSNKFEXT ERQUAL5002.   This occurs when the FTB
  P-lock exit is driven, but a control block associated
  with the index doesn't exist.  The control block was
  freed when the index was closed, but the FTB P-lock exit
  was still driven because the FTB P-lock was still held.
  

Problem conclusion

• The Db2 close logic for P-locks was fixed to ensure the FTB
  P-locks are freed.
  

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:

  UI68631

Modules/Macros

• DSNB1CPL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68631

     UP20/04/03 P F004

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.