DB2 - Problem description
Problem IT27809 | Status: Closed |
DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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 : follow-up : IT30808 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.01.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) |