Member-Scope Traces and Reports
Member-scope traces present events in chronological sequence within the DB2® subsystem (member) where the events occurred, whereas reports show these events aggregated by the OMEGAMON for Db2 Performance Expert identifiers you have specified.
OMEGAMON for Db2 Performance Expert can present data from several DB2 members within a data sharing group. The data in member-scope reports is presented by a combination of location, group, subsystem, and member. Whenever one of the values changes, a new page is started and the page number is initialized.
The information in this section is only applicable to DB2 data sharing environments.
Note: For an introduction to the Locking report set and general locking
information refer to the Reporting User's Guide.
Member-Scope Locking Trace
This is an example of a Member-Scope Locking trace.
LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:10:31.30440975 DEADLOCK COUNTER =11975 WAITERS = 2
SKA 'BLANK' C614015B874D N/P TSTAMP =06/04/15 08:10:31.28
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P64B.C614015B874D
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015B874D OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P64B.C614015B874D
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:10:36.28514203 DEADLOCK COUNTER =11976 WAITERS = 2
SKA 'BLANK' C614015B7C7C N/P TSTAMP =06/04/15 08:10:36.28
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P649.C614015B7C7C
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015B7C7C OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P649.C614015B7C7C
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-5
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:10:41.29402510 DEADLOCK COUNTER =11977 WAITERS = 2
SKA 'BLANK' C614015D652E N/P TSTAMP =06/04/15 08:10:41.28
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P654.C614015D652E
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-6
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015D652E OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P654.C614015D652E
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-7
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:10:51.32753756 DEADLOCK COUNTER =11979 WAITERS = 2
SKA 'BLANK' C614015B874D N/P TSTAMP =06/04/15 08:10:51.31
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P64B.C614015B874D
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-8
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015B874D OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P64B.C614015B874D
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-9
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:10:56.32255947 DEADLOCK COUNTER =11980 WAITERS = 2
SKA 'BLANK' C614015D652E N/P TSTAMP =06/04/15 08:10:56.32
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P654.C614015D652E
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-10
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015D652E OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P654.C614015D652E
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-11
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:11:11.38269228 DEADLOCK COUNTER =11983 WAITERS = 2
SKA 'BLANK' C614015D652E N/P TSTAMP =06/04/15 08:11:11.38
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P654.C614015D652E
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64B.C614015B874D
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-12
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015D652E OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64B.C614015B874D
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P654.C614015D652E
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-13
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 08:11:21.38524034 DEADLOCK COUNTER =11985 WAITERS = 2
SKA 'BLANK' C614015B7C7C N/P TSTAMP =06/04/15 08:11:21.38
DISTSERV SERVER TABLE DB =TDKDB HASH =X'00012011'
REQLOC :::FFFF:9.152.78. OB =32 ---------- BLOCKER is HOLDER --*VICTIM*-
ENDUSER :ska LUW=G9984E80.P649.C614015B7C7C
WSNAME :mupfel MEMBER =SZ11 CONNECT =SERVER
TRANSACT:java PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
STATE =S STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER ----------------
LUW=G9984E80.P64A.C614015B8346
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 18
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9' LOCATION: PMODBZ1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-14
GROUP: DBZ1 LOCKING TRACE - DEADLOCK REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ11 TO: NOT SPECIFIED
SUBSYSTEM: SZ11 ACTUAL FROM: 06/04/15 08:10:31.30
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 06/04/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA TABLE DB =TDKDB HASH =X'00012011'
SKA 'BLANK' C614015B7C7C OB =32 -----------BLOCKER IS WAITER------------
DISTSERV SERVER LUW=G9984E80.P64A.C614015B8346
REQLOC :::FFFF:9.152.78. MEMBER =SZ11 CONNECT =SERVER
ENDUSER :ska PLANNAME=DISTSERV CORRID =java
WSNAME :mupfel DURATION=COMMIT PRIMAUTH=SKA
TRANSACT:java STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
---------------- WAITER -------*VICTIM*-
LUW=G9984E80.P649.C614015B7C7C
MEMBER =SZ11 CONNECT =SERVER
PLANNAME=DISTSERV CORRID =java
DURATION=COMMIT PRIMAUTH=SKA
REQUEST =CHANGE WORTH = 17
STATE =X STMTINFO=DYNAMIC
ENDUSER =ska
WSNAME =mupfel
TRANSAC=java
PROGNAME=SYSSH200
COLLID =NULLID
LOCATION=N/P
CONTOKEN=X'5359534C564C3031'
STMTID =X'00000000000012B9'
LOCKING TRACE COMPLETE