Deadlock Trace Example
Deadlock trace example shows a sample deadlock trace, produced by the following command:
⋮
LOCKING
TRACE
LEVEL (DEADLOCK)
⋮Deadlock trace example
This is a sample deadlock trace:
LOCATION: OMPDA21 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: DBDAGROU LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: DA31MEMB TO: NOT SPECIFIED
SUBSYSTEM: DA31 ACTUAL FROM: 11/03/15 17:30:58.10
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 11/03/15
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE EVENT TIMESTAMP --- L O C K R E S O U R C E ---
PLANNAME CONNECT RELATED TIMESTAMP EVENT TYPE NAME EVENT SPECIFIC DATA
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SHA java DRDA 17:30:58.10472181 DEADLOCK COUNTER = 5243 WAITERS = 2
SHA 'BLANK' C508B221EA18 N/P TSTAMP =11/03/15 17:30:58.10
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00010B1E'
REQLOC :::FFFF:9.152.122 OB =11 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :sha LUW=G9987A4A.B5FF.C508B221EA18
WSNAME :miller MEMBER =DA31MEMB CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =S STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER ----------------
LUW=G9987A4A.B601.C508B2220AB3
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
TABLE DB =TDKDB HASH =X'00010B1E'
OB =11 -----------BLOCKER IS WAITER------------
LUW=G9987A4A.B601.C508B2220AB3
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER -------*VICTIM*-
LUW=G9987A4A.B5FF.C508B221EA18
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
SHA java DRDA 17:31:08.12271550 DEADLOCK COUNTER = 5245 WAITERS = 2
SHA 'BLANK' C508B2220AB3 N/P TSTAMP =11/03/15 17:31:08.10
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00010B1E'REQLOC :::FFFF:9.152.122 OB =11 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :sha LUW=G9987A4A.B601.C508B2220AB3
WSNAME :miller MEMBER =DA31MEMB CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =S STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER ----------------
LUW=G9987A4A.AB57.C5087DE5ED7E
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
TABLE DB =TDKDB HASH =X'00010B1E'
OB =11 -----------BLOCKER IS WAITER------------
LUW=G9987A4A.AB57.C5087DE5ED7E
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER -------*VICTIM*-
LUW=G9987A4A.B601.C508B2220AB3
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
SHA java DRDA 17:31:13.10897581 DEADLOCK COUNTER = 5246 WAITERS = 2
SHA 'BLANK' C50864AAC7BA N/P TSTAMP =11/03/15 17:31:13.10
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00010B1E'REQLOC :::FFFF:9.152.122 OB =11 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :sha LUW=G9987A4A.C220.C50864AAC7BA
WSNAME :miller MEMBER =DA31MEMB CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =S STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER ----------------
LUW=G9987A4A.AB57.C5087DE5ED7E
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
TABLE DB =TDKDB HASH =X'00010B1E'
OB =11 -----------BLOCKER IS WAITER------------
LUW=G9987A4A.AB57.C5087DE5ED7E
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER -------*VICTIM*-
LUW=G9987A4A.C220.C50864AAC7BA
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
SHA java DRDA 17:31:18.11530803 DEADLOCK COUNTER = 5247 WAITERS = 2
SHA 'BLANK' C508B221EA18 N/P TSTAMP =11/03/15 17:31:18.11
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00010B1E'
...REQLOC :::FFFF:9.152.122 OB =11 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :sha LUW=G9987A4A.B5FF.C508B221EA18
WSNAME :miller MEMBER =DA31MEMB CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =S STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER ----------------
LUW=G9987A4A.B601.C508B2220AB3
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
TABLE DB =TDKDB HASH =X'00010B1E'
OB =11 -----------BLOCKER IS WAITER------------
LUW=G9987A4A.B601.C508B2220AB3
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
---------------- WAITER -------*VICTIM*-
LUW=G9987A4A.B5FF.C508B221EA18
MEMBER =DA31MEMB CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SHA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=N/A
ENDUSER =sha
WSNAME =miller
TRANSAC=java
PROGNAME=SYSKA501
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =N/A
LOCKING TRACE COMPLETE