DB2 - Problem description
Problem IT34039 | Status: Closed |
TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAYRESULT IN DEADLOCK IN DPF ENVIRONMENT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
If you run two or more concurrent "lock table in exclusive mode" statements for CDE table in DPF environment, it may result in deadlock. This issue is specific to DPF environment. Here is an example of lock event monitor output on 11.5.2 or later: ------------------------------------------------------- Event ID : 1 Event Type : DEADLOCK Event Timestamp : 2020-08-25-01.12.27.167320 Partition of detection : 0 ------------------------------------------------------- Deadlock Graph -------------- Total number of deadlock participants : 2 Participant that was rolled back : 2 Type of deadlock : local Participant Participant Deadlock Member Application Handle Requesting Lock Holding Lock --------------- --------------- --------------- ------------------ 1 2 0 053 2 1 0 363 Participant No 2 requesting lock ---------------------------------- Lock Name : 0x00000000000000000000006ED3 Lock wait start time : 2020-08-25-01.12.20.004543 Lock wait end time : 2020-08-25-01.12.27.167320 Lock Type : SEQUENCE Lock Specifics : SEQ_OPERATION=LOCK_TABLE Lock mode requested : Exclusive Lock mode held : Exclusive ... Tablespace TID : Tablespace Name : Table FID : Table Schema : Table Name : Participant No 1 requesting lock ---------------------------------- Lock Name : 0x02000500000000000000000054 Lock wait start time : 2020-08-25-01.12.20.004365 Lock wait end time : 2020-08-25-01.12.27.167320 Lock Type : TABLE Lock Specifics : Lock mode requested : Exclusive Lock mode held : Exclusive ... Tablespace TID : 2 Tablespace Name : USERSPACE1 Table FID : 5 Table Schema : DB2V115 Table Name : T2 Attributes Requester Requester --------------------- ------------------------------ ------------------------------ Participant No 2 1 Application Handle 363 053 ... Agent Status Lock Wait Pending remote request ... Current Activities of Participant No 2 ---------------------------------------- ... Stmt type : Dynamic Stmt operation : DML, Lock Table Stmt no : -1 Stmt text : lock table t2 in exclusive mode Current Activities of Participant No 1 ---------------------------------------- ... Stmt type : Dynamic Stmt operation : DML, Lock Table Stmt no : -1 Stmt text : lock table t2 in exclusive mode | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.08.2020 10.06.2021 10.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |