APAR status
Closed as program error.
Error description
Incorrect Lock mode held output from lock event monitor , we have gotten the correct lock mode in sqlplGetHolderTidhdl , while we missed the lock mode parameter in monitoring related code 381354 data DB2 UDB lock manager sqlplGetHolderTidhdl fnc (3.3.35.282.0.1037) pid 6816152 tid 55483 cpid 5309066 node 0 probe 1037 bytes 28 Data1 (PD_TYPE_SQLP_TIDHDL,4) Transaction ID handle: 3 (User) Data2 (PD_TYPE_SQLP_LOCK_MODE,8) Lock Mode: SQLP_LOIX (.IX) - Intention Exclusive Lock 381356 data DB2 UDB lock manager sqlplGetBlockerTidhdl fnc (3.3.35.305.0.1109) pid 6816152 tid 55483 cpid 5309066 node 0 probe 1109 bytes 28 Data1 (PD_TYPE_SQLP_TIDHDL,4) Transaction ID handle: 3 (User) Data2 (PD_TYPE_SQLP_LOCK_MODE,8) Lock Mode: SQLP_LOIX (.IX) - Intention Exclusive Lock Example output as below , "Lock mode held none" was output in the event monitor ------------------------------------------------------- Event ID : 1 Event Type : LOCKWAIT Event Timestamp : 2018-12-20-11.30.08.383184 Partition of detection : 1 ------------------------------------------------------- Participant No 1 requesting lock ---------------------------------- Lock Name : 0x00030008000000000000000054 Lock wait start time : 2018-12-20-11.30.08.082151 Lock wait end time : 2018-12-20-11.30.28.144015 Lock Type : TABLE Lock Specifics : Lock Attributes : 00080000 Lock mode requested : Share Lock mode held : none------>>> Lock Count : 0 Lock Hold Count : 0 Lock rrIID : 0 Lock Status : Waiting Lock release flags : 00000000 Tablespace TID : 3 Tablespace Name : IBMDB2SAMPLEREL Table FID : 8 Table Schema : DB2SDIN1 Table Name : T1 deadlock.txt (9%) deadlock.txt (10%) Attributes Requester Owner --------------------- ------------------------------ ------------------------------ Participant No 1 2 Application Handle 12320 012781 Application ID *N1.db2sdin1.181220164248 *N0.db2sdin1.181220172141 Application Name db2bp db2bp Authentication ID DB2SDIN1 DB2SDIN1 Requesting AgentID 81728 82499 Coordinating AgentID 81728 82499 Agent Status UOW Executing UOW Waiting Application Action No action No action Lock timeout value 20 0 Lock wait value 300 0 Workload ID 1 1 Workload Name SYSDEFAULTUSERWORKLOAD SYSDEFAULTUSERWORKLOAD Service subclass ID 13 13 Service superclass SYSDEFAULTUSERCLASS SYSDEFAULTUSERCLASS Service subclass SYSDEFAULTSUBCLASS SYSDEFAULTSUBCLASS Current Request Open Cursor Execute Immediate TEntry state 1 2
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.5 or later * ****************************************************************
Problem conclusion
Upgrade to Db2 11.1.4.5 or later
Temporary fix
Comments
APAR Information
APAR number
IT27809
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
A50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-17
Closed date
2019-10-31
Last modified date
2019-10-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
31 October 2019