|
Problem IT30808
|
Status: Closed |
DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem 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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1.4.5 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : IT27809
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.10.2019
31.10.2019
31.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
