DBCTL
reports.
Figure 1. Sample
JCL CPADBCTL - DBCTL reports//CPADBCTL JOB ,CLASS=A,NOTIFY=&SYSUID
//CICSPA EXEC PGM=CPAMAIN,REGION=8M,PARM=NOSTAE
//STEPLIB DD DSN=CICSPA.V3R2M0.SCPALINK,DISP=SHR
//SYSPRINT DD SYSOUT=*
//*
//* SMF Input Files
//SMFIN001 DD DISP=SHR,DSN=<SMF.Input.DSN.applid1>
//*
//* Commands to request CICS PA reports
//SYSIN DD *
CICSPA IN(SMFIN001),
APPLID(<applid1>),
SELECT(PERF(EXCL(
CHARACTER(OWNER(DBCTL),SUBSTR(1,1),VALUE(' '))))),
SUMMARY( Sort by Tran ID and PSB name
FIELDS(TRAN, Transaction ID
DBCTL(PSBNAME), PSB name
TASKCNT, Task count
RESP(AVE,MAX), Response time
CPU(TIME,COUNT), CPU time
IMSREQCT, IMS (DBCTL) requests
IMSWAIT(TIME,COUNT), IMS (DBCTL) wait time
DBCTL(SCHTELAP(AVE,MAX), Schedule process elapsed
THREDCPU(AVE), DBCTL Thread CPU time
DLICALL(AVE)))), DLI calls
LIST(
FIELDS(TRAN, Transaction ID
DBCTL(PSBNAME), PSB name
RESP, Response time
CPU, CPU time
IMSREQCT, IMS (DBCTL) requests
IMSWAIT, IMS (DBCTL) wait time
DBCTL(SCHTELAP, Schedule process elapsed
POOLWAIT, Pool Space wait time
INTCWAIT, Intent Conflict wait time
DBIOELAP, Database I/O elapsed time
PILOCKEL, PI Lock elapsed time
THREDCPU, DBCTL Thread CPU time
DLICALL, DLI calls
DBIOCALL))) Database I/O calls
/*