Use your ISPF editor to create a JCL job that creates a
Utility Activity trace.
The following JCL is an example. Remember to change the setup information
(starting with // in your JCL) as appropriate for
your installation. Figure 1. Utility Activity job stream using ISPF/PDF editor
EDIT ---- ANDREW.OMPE.JOBS.UTTRA--------------------- Columns 001 072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** TOP OF DATA ******************************
0001 /* JCL to produce an Utility Activity Report */
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.UTI,DISP=SHR
0007 //DPMOUTDD DD DSN=ANDREW.OMPE.OUT.UTTRAC,DISP=OVR
0008 //JOBSUMDD DD SYSOUT=A
0009 //SYSIN DD *
0010 UTILITY
0011 TRACE
0012 TYPE(UTILITY)
0013 ORDER (PRIMAUTH-PLANNAME-INSTANCE)
0014 EXEC
0015 ****** **************************** 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
Example of a short Utility
Activity trace
The following example shows a trace produced
from this JCL job.
LOCATION: PMODA11GANZLANGE OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-1
GROUP: N/P UTILITY ACTIVITY TRACE REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA11 ACTUAL FROM: 07/25/15 10:14:19.95
DB2 VERSION: V10 PAGE DATE: 07/25/15
WORKLOAD(NONE)
IDENTIFIED BY PRIMAUTH/PLANNAME/INSTANCE
PRIMAUTH
PLANNAME START TIME ELAPSED TIME UTILITY-ID JOB NAME SHRLEVEL
INSTANCE SUBTASKS CPU TIME ACTIVITY TYPE DATABASE.PAGESET STEP TOT. ZIIP
SORT: DF DB2 DATA INDEX OTHER SORT CPU SORT ZIIP
---------------------- ----------- ------------ ----------------------- -----------------------------------------------------------
MTS
DSNUTIL
X'CBB6392D08E1' 10:14:19.95 3.360279 UTILITY LDTAB1V9 MTSLDA11 REFERENCE
0 1 0 0.651676 LOAD DBPARALL.TSPARALL LOADTAB1 0.077772
DBPARALL.XTAB1
DBPARALL.XTAB2
Y N 0 0 1 0.306264 0.000000
MTS
DSNUTIL
X'CBB639305E39' 10:14:23.32 1.918446 UTILITY LDTAB1V9 MTSLDA11 REFERENCE
N/A N/A N/A 0.323208 RUNSTATS DBPARALL.TSPARALL LOADTAB1 0.000000
DBPARALL.XTAB1
DBPARALL.XTAB2
N N N/A N/A N/A N/A N/A
UTILITY TRACE COMPLETE
The following sample Utility Activity trace is generated
with the following command:
TRACE
TYPE(BIND)
ORDER (PRIMAUTH-PLANNAME-INSTANCE)
LOCATION: OMPDB51 OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-1
GROUP: N/P UTILITY ACTIVITY TRACE REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 06/07/15 09:14:49.15
DB2 VERSION: V11 PAGE DATE: 06/07/15
WORKLOAD(NONE)
IDENTIFIED BY PRIMAUTH/PLANNAME/INSTANCE
PRIMAUTH
PLANNAME ELAPSED TIME
INSTANCE START TIME CPU TIME ACTIVITY TYPE OBJECT(S)
---------------------- ----------- ------------ ----------------------- -----------------------------------------------------------
KOZS
DSNBIND
X'CB79D25996E1' 09:14:49.15 0.001552 BIND
0.000000 BIND PLAN PLANNAME: DSNTIA11
KOZS
DSNBIND
X'CB79D25F57AF' 09:14:55.12 0.000643 BIND
0.000000 BIND PLAN PLANNAME: DSNTIAD
KOZS
DSNBIND
X'CB79D266C962' 09:15:02.92 0.000280 BIND
0.000000 BIND PLAN PLANNAME: DSNREXX
KOZS
DSNBIND
X'CB79D2F497B1' 09:17:31.62 0.005636 BIND
0.000000 FREE PLAN PLANNAME: LGNADML
KOZS
DSNBIND
X'CB79D3411068' 09:18:51.94 0.027328 BIND
0.000000 RBND PACK LOCN: OMPDB51
COLL: UTRUN
PKID: UTILV110
VRID: N/P
CONS: X'195D036002523DD6'
UTILITY TRACE COMPLETE