Fixes are available
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
RA50 PSN
UP
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022