BTLKCONT Lock Timeouts and Deadlocks Report

The BTLKCONT report shows contention information for the threads involved in any deadlock or timeout.
caidb219
The BTLKCONT report shows contention information for the threads involved in any deadlock or timeout.
Report characteristics:
  • Request type: Event Record Trace
  • Report format option: Non-column format
  • Records displayed: (045) LOCK-SUSPEND, (172) DEADLOCK, and (196) LOCK-TO-DETAIL (performance trace class 6)
MM/DD/YY 04:38:27 PAGE 1 REQUEST: BTLKCONT DB2 SYS: SSID FIRST RECORD MM/DD/YY 08:36:55 Lock Timeouts and Deadlocks DEADLOCK OCCURRED AT MM/DD/YY 08:36:55 Number of Resources 2 Interval count 3143945 Lock Resource 00004826.00000006 Type TABLE Holding task Lock mode IX Duration COMMIT Auth USER01 Member DH0G Stmt ID 00000000000252B6 Stmt type Static Plan DSNESPCS Connection TSO Corr ID USER01 Token 165494 Network USILDA01 LU name DH0GDB2 Instance CFE59B8BC36A Seq# 1 Program DSNESM68 Collection DSNESPCS Location ConToken 0E4D2F9F02F2F0F0 EndUser USER01 Workstation TSO Transaction USER01 Waiting task Lock mode X Duration COMMIT Function CHANGE Worth 11 * Victim * Auth USER01 Member DH3G Stmt ID 00000000000005C1 Stmt type Static Plan DISTSERV Connection SERVER Corr ID db2jcc_appli Token 21481 Network O2777B30 LU name E8D9 Instance CFE59B885B52 Seq# 5 Program SYSLH200 Collection NULLID Location ConToken 5359534C564C3031 EndUser USER01 Workstation 192.119.123.01 Transaction db2jcc_application Lock Resource 00004826.00000006 .PAGE X'00000006' Type DATAPAGE Holding task Lock mode X Duration COMMIT * Victim * Auth USER01 Member DH3G Stmt ID 00000000000005C1 Stmt type Static Plan DISTSERV Connection SERVER Corr ID db2jcc_appli Token 21481 Network O2777B30 LU name E8D9 Instance CFE59B885B52 Seq# 5 Program SYSLH200 Collection NULLID Location ConToken 5359534C564C3031 EndUser USER01 Workstation 192.119.123.01 Transaction db2jcc_application Waiting task Lock mode U Duration MANUAL Function LOCK Worth 11 Auth USER01 Member DH0G Stmt ID 00000000000252B6 Stmt type Static Plan DSNESPCS Connection TSO Corr ID USER01 Token 165494 Network USILDA01 LU name DH0GDB2 Instance CFE59B8BC36A Seq# 1 Program DSNESM68 Collection DSNESPCS Location ConToken 0E4D2F9F02F2F0F0 EndUser USER01 Workstation TSO Transaction USER01 MM/DD/YY 04:38:27 PAGE 2 REQUEST: BTLKCONT DB2 SYS: SSID FIRST RECORD MM/DD/YY 08:36:55 Lock Timeouts and Deadlocks TIMEOUT OCCURRED AT MM/DD/YY 11:05:39 Number of Threads 1 Timeout count 1 Timeout interval 60 Lock Resource 00004826.00000006 Type TABLE Waiting task Lock mode X Duration COMMIT Function CHANGE * Victim * Auth USER01 Member DH3G Stmt ID 00000000000005C1 Stmt type Dynamic Plan DISTSERV Connection SERVER Corr ID db2jcc_appli Network O2777B30 LU name C65D Instance CFE5BC8D4836 Seq# 5 EndUser USER01 Workstation 192.119.123.01 Transaction db2jcc_application Holding task Lock mode IS Duration COMMIT Type RS Task type LOCK HOLDER Auth USER01 Member DH0G Stmt ID 00000000000318C5 Stmt type Dynamic Plan DSNESPCS Connection TSO Corr ID USER01 Token 3104 Network USILDA01 LU name DH0GDB2 Instance CFE5BC87BF83 Seq# 1 EndUser USER01 Workstation TSO Transaction USER01