A fix is available
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 number
PH36531
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-21
Closed date
2021-05-13
Last modified date
2021-06-02
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
03 June 2021