A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00C90101 DSNIDBSE ERQUAL 5006 and then ABEND04E RC00C90101 DSNITCUS ERQUAL 5002 during the rollback of an INSERT. The rollback occurs when DB2 detects the page is in LPL. Additional Symptom: Db2 lock timeout (DSNT376I) occurred after Db2 restart completed due to not-released commit duration Dbet Entry Lock.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 11 for z/OS users entering * * log-apply undo phase and who have applied * * PH28600/UI72825. * **************************************************************** * PROBLEM DESCRIPTION: * * After PH28600/UI72825 was applied: * * 1. ABEND04E RC00C90101 DSNIDBSE * * ERQUAL5006, ABEND0C4 in DSNILSMG+017C2 * * and ABEND04E RC00C90101 DSNITCUS * * ERQUAL5002 during the backout of an * * INSERT transaction while the space * * map page was in LPL. * * 2. ABEND04E RC00C90101 DSNIBMOC * * ERQUAL500A or transaction timeout * * with reason code '00C9008E'X, or * * threads got hung/deadlock during the * * backout of an INSERT transaction * * while the space map page was in LPL. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** After PH28600/UI72825 was applied, during the backout of an INSERT transaction while the space map page was in LPL, the following two problems occurred: 1. For a non-partitioned table space, a bad partition number was set for the DBET request to mark the pageset for incremental COPY. This caused abends in DSNIDBSE ERQUAL5006, DSNILSMG+017C2 or DSNITCUS ERQUAL5002. 2. The COMMIT lock duration was set for the DBET request to mark the pageset for incremental COPY. This caused either the abend in DSNIBMOC ERQUAL500A or transaction timeout with reason code '00C9008E'X, or threads got hung/deadlock.
Problem conclusion
When backing out an INSERT transaction while the space map page is in LPL, in order to request DBET to mark the pageset for incremental COPY, Db2 code is modified to: 1. Provide DBET the correct partition information for any non-partitioned table space. 2. Provide DBET the MANUAL lock duration instead of COMMIT lock duration.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PH39383
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-28
Closed date
2021-08-10
Last modified date
2021-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI76668
Modules/Macros
DSNUBADR DSNUBAUS DSNILSMG DSNILSMU
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI76668
UP21/08/19 P F108
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":"11.0"}]
Document Information
Modified date:
02 September 2021