zOs/JCL/OMEGA
//A540769W JOB (CP00,KE50),'DB2 REO', 00010000
// MSGCLASS=T,TIME=1440, 00020000
// NOTIFY=&SYSUID,REGION=0M,SCHENV=DB2 00030000
//*MAIN CLASS=LOG 00031000
//* USEDPROC JCLLIB ORDER=DSN.RZ1.P0.DB2PDB.CNTL 00040000
//**********************************************************************00050000
//** A C C O U N T I N G **00060000
//**********************************************************************00070000
//PM EXEC PGM=DB2PM 00080000
//*STEPLIB DD DISP=SHR,DSN=OMEG.PLEXA.P420.PE.RKANMOD V4.1 00090000
//*STEPLIB DD DISP=SHR,DSN=DSN.PR.OMEG.V10.TKANMOD V5.1 00100000
//STEPLIB DD DISP=SHR,DSN=DSN.PR.OMEG.V10.TKANMOD 00110000
//SORTWK01 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00120000
//SORTWK02 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00130000
//SORTWK03 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00140000
//SORTWK04 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00150000
//SORTWK05 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00160000
//SORTWK06 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00170000
//SORTWK07 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00180000
//SORTWK08 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00190000
//SORTWK09 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00200000
//SORTWK10 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(800,400)) 00210000
//ACWORK DD DISP=(NEW,PASS), 00220000
// DSN=&&ACWORK, 00230000
// SPACE=(CYL,(800,400),RLSE),DCB=(BUFNO=20), 00240000
// RECFM=VBS,LRECL=32756,BLKSIZE=6233, 00250000
// DATACLAS=NULL8,MGMTCLAS=COM#E000 00260000
//SQLWORK DD DISP=(NEW,PASS), 00270000
// DSN=&&SQLWORK, 00280000
// SPACE=(CYL,(800,400),RLSE),DCB=(BUFNO=20), 00290000
// RECFM=VBS,LRECL=32756,BLKSIZE=6233, 00300000
// DATACLAS=NULL8,MGMTCLAS=COM#E000 00310000
//**********************************************************************00320000
//** INPUT - DATASET **00330000
//**********************************************************************00340000
//SMFIN DD DISP=SHR,DSN=SMF.RZ2.P0.DB2.INTVL.S22B.D14288.T040100 00350000
//**********************************************************************00360000
//SYSOUT DD SYSOUT=*,OUTLIM=9999999 00370000
//SYSMDUMP DD SYSOUT=* 00380000
//*USSFILE DD DSN=&&TEMP,DISP=(NEW,PASS,KEEP) 00390000
//JOBSUMDD DD SYSOUT=* 00400000
//SYSIN DD * 00410000
GLOBAL 00420000
* TIMEZONE(ZH) 00430000
INPUTDD(SMFIN) 00440000
* INCLUDE(GROUP(DP4G)) 00450000
* INCLUDE(MEMBER(DP42)) 00460000
* FROM(01/24/14,15:30:00) TO(01/24/14,15:31:00) 00470000
* FROM(04/30/11,04:00:00) TO(04/30/11,05:00:00) 00480000
* FROM(08/25/14,09:30:00) TO(08/25/14,09:35:00) 00490000
* INCLUDE(CORRNAME(Y4PRDIVE)) 00500000
* INCLUDE(PRIMAUTH(S100447)) 00510000
* INCLUDE(PLAN(DSNTEP2)) 00520000
INCLUDE(PLAN(WB0870)) 00530000
ACCOUNTING 00540000
* REPORT LAYOUT(LONG) DDNAME(USSFILE) 00550000
REPORT LAYOUT(SHORT) ORDER(CORRNAME) DDNAME(ACCTshrt) 00560000
REPORT LAYOUT(LONG) ORDER(CORRNAME) DDNAME(ACCTlong) 00570000
********************************************************** 00580000
* STATISTICS 00590000
* REPORT LAYOUT(LONG) 00600000
* dsetstat 00610000
* ORDER(INTERVAL) 00620000
* DDNAME(STATlong) 00630000
* REPORT LAYOUT(SHORT) 00640000
* dsetstat 00650000
* ORDER(INTERVAL) 00660000
* DDNAME(STATshrt) 00670000
********************************************************** 00680000
SQLACTIVITY 00690000
REPORT 00700000
SUMMARIZEBY(STMTNO) 00710000
WORKLOAD(ALL) order(corrname) DDNAME(SQLall) 00720000
REPORT 00730000
SUMMARIZEBY(STMTNO) 00740000
WORKLOAD(ACCT) order(corrname) DDNAME(SQLacct) 00750000
REPORT 00760000
SUMMARIZEBY(STMTNO) 00770000
WORKLOAD(IO) order(corrname) DDNAME(SQLio) 00780000
REPORT 00790000
SUMMARIZEBY(STMTNO) 00800000
WORKLOAD(LOCK) order(corrname) DDNAME(SQLlock) 00810000
REPORT 00820000
SUMMARIZEBY(STMTNO) 00830000
WORKLOAD(SCAN) order(corrname) DDNAME(SQLscan) 00840000
00850000
TRACE 00860000
* workload(all) 00870000
workload(hilite) 00880000
SUMMARIZEBY(STMTNO) 00890000
* SUMARIZEBY (ALL) 00900000
SORTBY (TCBTIME) 00910000
DDNAME(SQLtrace) 00920000
********************************************************** 00930000
LOCKING 00940000
REPORT LEVEL(LOCKOUT) order(corrname) ddNAME(LOCKout) 00950000
REPORT LEVEL(SUSPENSION) order(corrname) DDNAME(LOCKsusp) 00960000
trace LEVEL(DETAIL) DDNAME(LOCKtrc) 00970000
trace LEVEL(suspension) DDNAME(LOCKtrcs) 00980000
trace LEVEL(lockout) DDNAME(LOCKtrcl) 00990000
********************************************************** 01000000
IOACTIVITY 01010000
REPORT LEVEL(SUMMARY) DDNAME(IOsum) 01020000
REPORT LEVEL(BUFFER) order(bpid) DDNAME(IObuf1) 01030000
REPORT LEVEL(BUFFER) order(corrname) DDNAME(IObuf2) 01040000
* REPORT LEVEL(EDM) order(corrname) DDNAME(IOedm) 01050000
* REPORT LEVEL(ACTLOG) order(corrname) DDNAME(IOact) 01060000
REPORT LEVEL(ARCLOG) order(corrname) DDNAME(IOarc) 01070000
REPORT LEVEL(XI) order(planname) DDNAME(IOxi) 01080000
********************************************************** 01090000
* RECTRACE 01100000
* TRACE LEVEL(SHORT) DDNAME(RECshrt) 01110000
* TRACE LEVEL(LONG) DDNAME(REClong) 01120000
EXEC 01130000
//**********************************************************************01140000
// 01150000
INCLUDE (PLAN(WB0870)) 01160000
01170000
GLOBAL 01180000
TIMEZONE(ZH) 01190000
01200000
ACCOUNTING 01210000
REPORT 01220000
LAYOUT(LONG) 01230000
DDNAME(USSFILE) 01240000
REPORT 01250000
LAYOUT(LONG) 01260000
DDNAME(DYN1) 01270000
EXEC 01280000
//**********************************************************************01290000
//** USS **01300000
//**********************************************************************01310000
//CLEANUP EXEC PGM=IEFBR14 01320000
//DATASET DD PATHDISP=(DELETE,DELETE), 01330000
// PATHOPTS=(OWRONLY,OCREAT), 01340000
// PATH='/u/a458914/TEMP/Accounting.txt' 01350000
//USSCOPY EXEC PGM=IKJEFT01 01360000
//SYSUT1 DD DISP=SHR,DSN=*.PM.USSFILE 01370000
//SYSTSPRT DD SYSOUT=* 01380000
//SYSTSIN DD * 01390000
ALLOCATE FILE(sysut2) PATH('/u/a458914/TEMP/Accounting.txt') - 01400000
FILEDATA(TEXT) - 01410000
PATHOPTS(OWRONLY,OCREAT) - 01420000
PATHMODE(SIRWXU,SIRGRP) 01430000
call *(EDCICONV) 'FROMCODE(IBM-500),TOCODE(IBM-1047)' 01440000
OCOPY INDD(sysut1) OUTDD(sysut2) - 01450000
CONVERT('SYS1.LINKLIB(BPXFX450)') 01460000
/* 01470000
// 01480000
FROM(11/09/06,00:00:00) 01490000
TO(11/09/06,12:00:00) 01500000