zOs/JCL/DB21DMP
//A540769S JOB (CP00,KE50), 00010001
// MSGCLASS=T,TIME=1440,LINES=(999999,WARNING),
// NOTIFY=A540769
//*MAIN CLASS=LOG,SYSTEM=S13
//**********************************************************************
//* --> stop trace mittels: -sto trace(perfm)
//*
//* --> kein output: eventuell bufsize reduzieren
//* (beim stop trace wird der aktuelle buffer nicht mehr
//* geschrieben|)
//*
//**********************************************************************
//IFCSD EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SDMPPRNT DD SYSOUT=*
//SDMPTRAC DD DISP=(NEW,CATLG,CATLG),DSN=A540769.DB2TRACE.DATA.#DT#,
// UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE),MGMTCLAS=COM#A045,
//*DMPTRAC DD SYSOUT=*,
// DCB=(DSORG=PS,LRECL=8188,RECFM=VB,BLKSIZE=8192)
//SDMPIN DD *
START TRACE(PERFM)
CLASS (30) RMID (*) DEST (OPX) BUFSIZE(256)
CORRID(A540769)
IFCID(3,6,7,8,9,11,12,13,15,16,17,18,22,28,45,53,55,58,59,60,
61,62,63,64,65,66,68,69,70,71,72,73,74,75,84,85,86,87,
88,89,92,95,96,97,105,106,107,108,109,125,157,159,160,
162,163,174,175,177,183,188,214,215,216,221,222,226,227,
231,233,237,242,247,248,272,273,305,324,325)
FOR(32767)
//SDMPIN91 DD *
START TRACE(PERFM)
CLASS (30) RMID (*) DEST (OPX)
PKGCOL(SV) PKGPROG(SV0020)
IFCID(3,6,7,8,9,11,12,13,15,16,17,18,22,28,45,53,55,58,59,60,
61,62,63,64,65,66,68,69,70,71,72,73,74,75,84,85,86,87,
88,89,92,95,96,97,105,106,107,108,109,125,157,159,160,
162,163,174,175,177,183,188,214,215,216,221,222,226,227,
231,233,237,242,247,248,272,273,305,324,325) BUFSIZE(512)
FOR(299)
//SDMPIN92 DD *
START TRACE(PERFM) CLASS(3) DEST(OPX) CORRID(A54076*)
BUFSIZE(1024)
FOR (99)
//SDMPIX93 DD *
CLASS(6) DEST(OPX) PLAN(DSNUTIL) AUTHID(A540769)
CORRID(A540769L)
//**********************************************************************
//* START TRACE(PERFM) CLASS(*) DEST(OPX) PLAN(DISTSERV) BUFSIZE(32)
//* START TRACE(PERFM) CLASS(30) DEST(OPX) PLAN(WI0380) BUFSIZE(1024)
//*
//* SUSPENSION TRACE:
//* CLASS(6) DEST(OPX) PLAN(PW5200,PW5230) BUFSIZE(1024)
//*
//* SQL TRACE:
//* START TRACE(PERFM) CLASS(3) DEST(OPX) PLAN(A167274) BUFSIZE(32)
//*
//* SQL TRACE (LONG SQL-STMT):
//* START TRACE(PERFM) CLASS(3) DEST(OPX) PLAN(A167274) BUFSIZE(32)
//*
//* DS OPEN/CLOSE
//* START TRACE(PERFM) CLASS(1) IFCID(107) DEST(OPX) BUFSIZE(1024)
//*
//* INSERT SDMPIN DD HERE. IT MUST BEGIN WITH A VALID
//* START TRACE COMMAND (WITHOUT THE SUBSYSTEM RECOGNITION CHAR)
//*
//**********************************************************************
/*
//**********************************************************************
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DBAF)
RUN PROG(DSN1SDMP) PLAN(DSNTEP2)
END
//********** ANALYSIS
//PMV710 EXEC PGM=DB2PM
//STEPLIB DD DSN=OMEG.PLEXA.P420.PE.RKANMOD,DISP=SHR
//*
//* INPUT stat files suffice for locking
//*INPUTDD DD DISP=SHR,DSN=SMF.RZ2.P0.DB2.INTVL.S24B.D11286.T235930
//INPUTDD DD DISP=SHR,DSN=*.IFCSD.SDMPTRAC
//*
//*
//SORTWK01 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK02 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK03 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK04 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK05 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK06 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK07 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK08 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK09 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK10 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK11 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK12 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK13 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK14 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK15 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK16 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK17 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK18 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK19 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK21 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK22 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK23 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK24 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK25 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK26 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK27 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK28 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK29 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK30 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK31 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK32 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK33 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK34 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK35 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK36 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK37 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK38 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK39 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK40 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK41 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK42 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK43 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK44 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK45 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK46 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK47 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK48 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK49 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK50 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK51 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK52 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK53 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK54 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//SORTWK55 DD UNIT=SYSDA,DISP=(,DELETE),SPACE=(CYL,(600,600))
//*
//ACWORK DD UNIT=DISK,DISP=(NEW,CATLG,DELETE),
// DSN=&&ACWORK,
// SPACE=(CYL,(600,300),RLSE),DCB=(BUFNO=20),
// RECFM=VBS,LRECL=32756,BLKSIZE=6233,
// DATACLAS=NULL12,MGMTCLAS=COM#A032
//*
//* ** DATASET WIRD FÜR ACCOUNTING TRACES VERWENDET
//ACMEM01 DD UNIT=DISK,DISP=(NEW,CATLG,DELETE),
// DSN=&&ACME01,
// SPACE=(CYL,(800,400),RLSE),DCB=(BUFNO=20),
// RECFM=VBS,LRECL=32756,BLKSIZE=6233,
// DATACLAS=NULL8,MGMTCLAS=COM#E000
//ACMEM02 DD UNIT=DISK,DISP=(NEW,CATLG,DELETE),
// DSN=&&ACME01,
// SPACE=(CYL,(800,400),RLSE),DCB=(BUFNO=20),
// RECFM=VBS,LRECL=32756,BLKSIZE=6233,
// DATACLAS=NULL8,MGMTCLAS=COM#E000
//ACMEM03 DD UNIT=DISK,DISP=(NEW,CATLG,DELETE),
// DSN=&&ACME01,
// SPACE=(CYL,(800,400),RLSE),DCB=(BUFNO=20),
// RECFM=VBS,LRECL=32756,BLKSIZE=6233,
// DATACLAS=NULL8,MGMTCLAS=COM#E000
//DPMPARMS DD DSN=DSN.RZ1.P0.DPMPARMS,DISP=SHR ,DI
//ACTRCDD1 DD SYSOUT=*
//ACRPTDD DD SYSOUT=*
//DPMLOG DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//*
//JOBSUMDD DD SYSOUT=* <--- JOB SUMMARY REPORT
//*
//DEAD#TRC DD SYSOUT=*
//*DEAD#TRC DD DISP=(NEW,CATLG,DELETE), DEADLOCK REPORT
//* SPACE=(CYL,(1,1),RLSE),MGMTCLAS=A035N004,
//* DSN=TSS.SKA.DATA.BE2.DEADLOC2.#DT#
//*LOCK#TRC DD DISP=(NEW,CATLG,DELETE), DEADLOCK REPORT
//* SPACE=(CYL,(1,1),RLSE),MGMTCLAS=A035N004,
//* DSN=TSS.SKA.DATA.BE2.DEADLOCK.#DT#
//LORPTDD DD SYSOUT=* locking report
//LOTRCDD1 DD SYSOUT=* locking trace
//LOTRCDD2 DD SYSOUT=*
//LOTRCDD3 DD SYSOUT=*
//LOTRCDD4 DD SYSOUT=*
//*
//ACRPTDD DD SYSOUT=* accounting report
//ACTRCDD1 DD SYSOUT=* accounting trace
//ACTRCDD2 DD SYSOUT=*
//*
//SYSPARMS DD SYSOUT=* sysParms REPORT
//*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
GLOBAL
/* PAGESIZE(55) */
/* INPUTDD(SMFIN) */
PRESORTED(NO)
TIMEZONE(ZH)
SQLACTIVITY
TRACE
WORKLOAD(ALL)
/* WORKLOAD(HILITE) */
/* WORKLOAD(ACCT) */
LIMIT(99999)
REPORT
/* SUMMARIZEBY(ALL) */
/* SUMMARIZEBY(STMTTYPE) */
SUMMARIZEBY(STMTNO)
/* SUMMARIZEBY(CURSOR) */
WORKLOAD(ALL)
/* WORKLOAD(HILITE) */
/* WORKLOAD(NONE) */
ORDER(PLANNAME)
EXEC