Example of a command string
This example shows a JCL that produces a short Accounting report and a long Statistics trace.
EDIT ---- SYS92226.T092210.RA000.USERPMA.R000003 ------------ Columns 001 072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** TOP OF DATA ******************************
0001 //USERPMA JOB (TTS1,YUS7),'ANDREW',
0002 // MSGCLASS=V,CLASS=D,NOTIFY=USERPM
0003 // EXEC PGM=FPECMAIN,PARM='DATEFORMAT=MM/DD/YY'
0004 //STEPLIB DD DSN=OMPE.RKANMOD,DISP=SHR
0005 //INPUTDD DD DSN=OMPE.RKO2DATA(FPECIVPI),DISP=SHR
0006 //JOBSUMDD DD SYSOUT=A
0007 //SYSIN DD *
0008 GLOBAL
0009 FROM (04/01/15,08:00)
0010 TO (04/01/15,09:00)
0011 ACCOUNTING
0012 REPORT
0013 FROM (04/01/15,08:48)
0014 TO (04/01/15,08:52)
0015 STATISTICS
0016 TRACE
0017 LAYOUT(LONG)
0018 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=CancelThe first two lines are user and environment settings. Change these settings according to your operating environment.
Line 3 contains the call to OMEGAMON for Db2 Performance Expert. The DATEFORMAT parameter determines the mm/dd/yy format (which is the default format, so it is not strictly necessary to be declared in the job stream).
The STEPLIB statement (line 4) must be modified to point to your OMEGAMON for Db2 Performance Expert installation.
The SYSIN statement (line 5) indicates that the command string is contained within this JCL.
The INPUTDD statement (line 6) specifies the input data set that contains Db2 trace data.
The GLOBAL command (line 8) restricts the data that is passed from the input data set to the ACCOUNTING and STATISTICS commands. Only data between the specified FROM and TO dates and times is made available to the commands.
The ACCOUNTING command (line 11) produces an Accounting report. The REPORT subcommand (line 12) is not strictly necessary because REPORT is the default subcommand for ACCOUNTING. The FROM and TO subcommand options (lines 13 and 14) restrict the period of the Accounting report to 30 minutes. When you use these subcommand options, ensure that the period is within the period specified by the GLOBAL command. Otherwise, no report is generated.
The STATISTICS command (line 15), its TRACE subcommand (line 16), and its LAYOUT subcommand option (line 17) produce a long Statistics trace.
You must include the EXEC statement (line 18) to generate the reports. Otherwise, no report is generated.
Because no explicit output data sets are specified in this example, the reports will be written to ACRPTDD for the Accounting report and STTRCDD1 for the Statistics trace, which are the default ddnames.
SUBMIT on the command
line and press Enter.
EDIT ---- SYS92226.T092210.RA000.USERPMPA.R0000003 ---------- Columns 001 072
Command ===> SUBMIT__________________________________________ Scroll ===> CSR_
****** ***************************** TOP OF DATA ******************************
000001 //USERPMA JOB (TTS1,YUS7),'ANDREW',
⋮
The syntax of your JCL is checked and written to the DPMLOG data set, together with any information, warning, or error messages raised.
Accounting report - model layout SHORT
The following example shows an Accounting report produced in the previous JCL.
LOCATION: OMPD951 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: 04/01/15 08:48:00.00
MEMBER: N/P TO: 04/01/15 08:52:00.00
SUBSYSTEM: D951 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 04/01/15 08:49:47.77
DB2 VERSION: V10 SCOPE: MEMBER TO: 04/01/15 08:50:34.04
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
--------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DNSK 1 1 0.00 0.00 0.00 0.051437 N/P 0.00
'BLANK' 0 0.00 0.00 0.00 0.051442 0.000388 N/P 0
0 0.00 0.00 0.00 0.000394 N/P N/P
DNSK 1 1 0.00 1.00 1.00 0.027885 0.00 0.00
DSNREXX 0 0.00 0.00 1.00 0.030849 0.002257 0.00 0
0 1.00 0.00 0.00 0.003204 19.00 0.00
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|DSNREXX PACKAGE 1 1 5.00 0.027877 0.002249 0.000000 0.00|
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DNSK 2 2 0.00 0.50 0.50 0.039661 0.00 0.00
0 0.00 0.00 0.50 0.041146 0.001322 0.00 0
0 0.50 0.00 0.00 0.001799 19.00 0.00
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP|
|ALL PROG PACKAGE 1 1 5.00 0.027877 0.002249 0.000000 0.00|
----------------------------------------------------------------------------------------------------------------
ACCOUNTING REPORT COMPLETE