Creating a Detail Locking trace
Use your ISPF editor to create a JCL job that creates a Detail Locking trace.
The following JCL is an example. Remember to change the setup information
(starting with Figure 1. Locking
activity job stream using ISPF/PDF editor
// in your JCL) as appropriate for
your installation.
EDIT ---- ANDREW.OMPE.JOBS.LOKTRC--------------------- Columns 001 072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** TOP OF DATA ******************************
0001 /* JCL to produce a Locking detail trace */
0002 //AWOMPEA JOB (TTS1,YUS7),'ANDREW',
0003 // MSGCLASS=V,CLASS=D,NOTIFY=ANDREW
0004 // EXEC PGM=FPECMAIN
0005 //STEPLIB DD DSN=OMPE.RKANMOD,DISP=SHR
0006 //INPUTDD DD DSN=ANDREW.OMPE.TRACES.LOCKDT,DISP=SHR
0007 //DPMOUTDD DD DSN=ANDREW.OMPE.OUT.LOCK1,DISP=OVR
0008 //JOBSUMDD DD SYSOUT=A
0009 //SYSIN DD *
0010 LOCKING
0011 TRACE
0012 LEVEL (DETAIL)
0013 SCOPE (MEMBER)
0014 EXEC
****** **************************** BOTTOM OF DATA ****************************
F1=Help F2=Split F3=Exit F5=Rfind F6=Rchange F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel
To submit the job, type SUBMIT on the command
line and press Enter.
Example of a detail Locking trace
The following example shows a detail Locking trace.
LOCATION: USIBMSYSTDB2 OMEGAMON for Db2 Performance Expert (V5R5M0) PAGE: 1-4
GROUP: USIBMSYSTDB2 LOCKING TRACE - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U TO: NOT SPECIFIED
SUBSYSTEM: DB2U ACTUAL FROM: 08/14/15 19:32:57.03
Db2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 08/14/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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
USER005 NOPID IMS-MPP 19:32:57.03444843 LOCK PAGESET DB =DSNDB01 DURATION=ALLOCATN STATE=IS XES PROP=N
USER005 0002 A9BA4BA9A1A6 REQUEST OB =SCT02 RSN CODE=X'20' RTNCD= 4 XES FORC=N
NOPID IMSA NMODIFY GLOBAL L-LOCK
HASH =X'00000BC0'
19:32:57.05134612 LOCK DATAPAGE DB =DSNDB01 DURATION=MANUAL STATE=S XES PROP=N
REQUEST OB =SCT02 RSN CODE= 0 RTNCD= 0 XES FORC=N
PAGE=X'0000009A' NMODIFY GLOBAL L-LOCK
PARENT =X'03E490C8'
HASH =X'00019A5F'
19:32:57.07211528 LOCK SKCT PLAN=NOPID DURATION=INTEREST STATE=IS XES PROP=Y
REQUEST RSN CODE= 0 RTNCD= 0 XES FORC=N
NMODIFY GLOBAL P-LOCK XES ASYN=N
HASH =X'11969789'
19:32:57.07269878 UNLOCK DATAPAGE DB =DSNDB01 DURATION=MANUAL STATE=S XES PROP=N
19:32:57.05134612 REQUEST OB =SCT02 RSN CODE= 0 RTNCD= 0 XES FORC=N
PAGE=X'0000009A' NMODIFY GLOBAL L-LOCK
HASH =X'00019A5F'
19:32:58.89454559 LOCK OPENLOCK DB =TPCCE1 DURATION=MANUAL STATE=X XES PROP=Y
SUSPEND OB =TCUST000 ORIG.RSN=INTER SYSTEM XES FORC=N
NMODIFY GLOBAL L-LOCK XES ASYN=Y
PARENT =X'01020006'
HASH =X'00002080'
19:32:58.89622303 LOCK OPENLOCK DB =TPCCE1 SUSP.TIME =0.001677 LOCAL CONTENTION=N
19:32:58.89454559 RESUME OB =TCUST000 DURATION =MANUAL LATCH CONTENTION=N
STATE =X IRLM QUEUED REQ =N
RESUME RSN=NORMAL GLOBAL CONT. =N*
XES PROP =Y NOTIFY MSG SENT =N
XES FORC =N
XES ASYN =Y RETAINED LOCK =Y
NMODIFY GLOBAL L-LOCK
PARENT =X'01020006'
HASH =X'00002080'
19:32:58.89633406 LOCK OPENLOCK DB =TPCCE1 DURATION=MANUAL STATE=X XES PROP=Y
REQUEST OB =TCUST000 RSN CODE= 0 RTNCD= 0 XES FORC=N
NMODIFY GLOBAL L-LOCK XES ASYN=Y
HASH =X'00002080'
19:32:58.89738515 LOCK GBP CONV DB =TPCCE1 DURATION=MANUAL STATE=S XES PROP=Y
REQUEST OB =TCUST000 RSN CODE= 0 RTNCD= 0 XES FORC=N
NMODIFY GLOBAL L-LOCK XES ASYN=N
HASH =X'00000403'
19:32:58.89859378 LOCK P/P PLCK DB =TPCCE1 DURATION=INTEREST STATE=S XES PROP=Y
REQUEST OB =TCUST000 RSN CODE= 0 RTNCD= 0 XES FORC=N
BPID=BP0 NMODIFY GLOBAL P-LOCK XES ASYN=N
CACHE =S
HASH =X'00000402'
19:32:58.89876712 P-LOCK P/P PLCK DB =TPCCE1 REQUEST=LOCK OBJECT=TABLESPACE
REQUEST OB =TCUST000 MEMBER =N/A REQUESTED STATE=S
BPID=BP0 OLD STATE=NH OLD CACHED STATE=NH
NEW STATE=S NEW CACHED STATE=S
CONDITIONAL RESTART NONMODIFY
19:32:58.89943440 UNLOCK GBP CONV DB =TPCCE1 DURATION=MANUAL STATE=X'00' XES PROP=Y
19:32:58.89738515 REQUEST OB =TCUST000 RSN CODE= 0 RTNCD= 0 XES FORC=N
NMODIFY LOCAL L-LOCK XES ASYN=N
HASH =X'00000000'
19:32:59.91957718 UNLOCK OPENLOCK DB =TPCCE1 DURATION=MANUAL STATE=X XES PROP=Y
19:32:58.89633406 REQUEST OB =TCUST000 RSN CODE= 0 RTNCD= 0 XES FORC=N
NMODIFY GLOBAL L-LOCK XES ASYN=N
HASH =X'00002080'
19:32:59.93528409 LOCK DATAPAGE DB =TPCCE1
AVOIDANCE OB =TCUST000
PAGE=X'00000002'
19:33:02.09291456 LOCK DATAPAGE DB =TPCCE1 DURATION=MANUAL STATE=U XES PROP=Y
REQUEST OB =TSTCK000 RSN CODE= 0 RTNCD= 0 XES FORC=N
PAGE=X'00003A55' NMODIFY GLOBAL L-LOCK XES ASYN=N
PARENT =X'03E494C8'
HASH =X'000055FA'
19:33:02.09579509 CHANGE DATAPAGE DB =TPCCE1 DURATION=COMMIT STATE=X XES PROP=Y
19:33:02.09291456 REQUEST OB =TSTCK000 RSN CODE= 0 RTNCD= 0 XES FORC=N
PAGE=X'00003A55' MODIFY GLOBAL L-LOCK XES ASYN=N
HASH =X'000055FA'
19:33:02.35630903 CLAIM PAGESET DB =TPCCE1 CLASS=WRITE
N/P RELEASE OB =TSTCK000 RSN CODE= 0 RTNCD= 0
19:33:02.35708056 LOCK ALL MAX PAGE & ROW LOCKS= 11 LOCKAV=YES
SUMMARY PAGESETS SHARED ESCAL= 0 EXCLUS.ESCAL= 0
PAGESET DB =DSNDB01 MAX PAGE & ROW LOCKS= 1 LOCKAV=NO
OB =SCT02 TABLESPACE TYPE=UNSEGMENTED SIZE=PAGE
MAX STATE=IS NO ESCALATIONS
PAGESET DB =TPCCE1 MAX PAGE & ROW LOCKS= 1 LOCKAV=YES
OB =TCUST000 TABLESPACE TYPE=UNSEGMENTED SIZE=PAGE
MAX STATE=IS NO ESCALATIONS
PAGESET DB =TPCCE1 MAX PAGE & ROW LOCKS= 3 LOCKAV=NO
OB =TSTCK000 TABLESPACE TYPE=UNSEGMENTED SIZE=PAGE
MAX STATE=IX NO ESCALATIONS
19:33:02.36281765 UNLOCK N/P N/P DURATION=COMMIT STATE=X'00' XES PROP=Y
MASS REQUEST RSN CODE=X'02' RTNCD= 4 XES FORC=N
NMODIFY LOCAL L-LOCK XES ASYN=N
HASH =X'00000000'