A fix is available
APAR status
Closed as program error.
Error description
Deadlock trace IFCID 172 contains incorrect holder information.
Local fix
STMTID is correct to identify the deadlock holder.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 for z/OS users. * **************************************************************** * PROBLEM DESCRIPTION: * * Db2 IFCID 172 records may contain * * wrong information for holder's * * PLANNAME,CORRID,CONNNAME,LUWID * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Db2 deadlock trace record in IFCID 172 may show information for the holder which does not match correctly with the actual holder's data. This may happen during a timing window when the holder has changed when the Deadlock Exit was called.
Problem conclusion
This APAR changes the code in Db2 Deadlock Exit to correctly record the lock holder's information when it is available on the local member. In a situation when Db2 cannot find the matching information for the lock holder, it will fill the ifcid 172 fields QW0172HP(PLAN NAME), QW0172HR(CORRID), QW0172HN(CONN NAME), QW0172HL(LUWID) plus others with '*' meaning information not available.
Temporary fix
Comments
APAR Information
APAR number
PH06873
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-02
Closed date
2020-06-23
Last modified date
2020-07-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70199 UI70200
Modules/Macros
DSNTLDEA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 July 2020