DB2® report.
Figure 1. Sample JCL CPADB2 - DB2 report//CPADB2 JOB ,CLASS=A,NOTIFY=&SYSUID
//CICSPA EXEC PGM=CPAMAIN,REGION=4M,PARM=NOSTAE
//STEPLIB DD DSN=CPA.V3R2M0.SCPALINK,DISP=SHR
//SYSPRINT DD SYSOUT=*
//* SMF Input Files
//SMFIN001 DD DISP=SHR,DSN=<SMF.Input.DSN.applid1>
//SMFIN002 DD DISP=SHR,DSN=<SMF.Input.DSN.db2ssid1>
//* External Work Data Sets
//CPAXW001 DD DISP=(NEW,DELETE),UNIT=SYSDA,SPACE=(CYL,(50,10))
//* Sort Work Data Sets
//CPASWK01 DD DISP=(NEW,DELETE),UNIT=SYSDA,SPACE=(CYL,(20,5))
//CPASWK02 DD DISP=(NEW,DELETE),UNIT=SYSDA,SPACE=(CYL,(20,5))
//CPASWK03 DD DISP=(NEW,DELETE),UNIT=SYSDA,SPACE=(CYL,(20,5))
//CPASWK04 DD DISP=(NEW,DELETE),UNIT=SYSDA,SPACE=(CYL,(20,5))
//SYSOUT DD SYSOUT=*
//* Commands to request CICS PA reports
//SYSIN DD *
CICSPA IN(SMFIN001,SMFIN002),
APPLID(<applid1>),
* DB2 Reports...
DB2(OUTPUT(DB200001),
EXTERNAL(CPAXW001),
* CMFONLY, Only process CMF Performance records.
* Do not process DB2 accounting (101)
* records.
* SSID(DB2*,PR*), DB2 Subsystem IDs.
* If not specified, all DB2 SSIDs used
* by the CICS APPLIDs are reported.
* Masking characters (*%) allowed.
*
LIST( Detailed list of all DB2 UOWs
CLASS1, Class1: Thread Time
CLASS2, Class2: In-DB2 Time
CLASS3, Class3: Suspend Time
BUFFER, Buffer Manager Summary
LOCKING, Locking Summary
DML1, SQL DML Query/Update
DML2), SQL DML 'Other'
LISTZERO, In the detailed list, report all tasks
* in a Network UOW, even when DB2REQCT=0
LONGSUMM( Long Summary of DB2 activity
CLASS1, Class1: Thread Time
CLASS2, Class2: In-DB2 Time
CLASS3, Class3: Suspend Time
BUFFER, Buffer Manager Summary
LOCKING, Locking Summary
DML1, SQL DML Query/Update
DML2), SQL DML 'Other'
MAXLONGSUM, Include maximums in the Long Summary.
* This is the default.
* Specify NOMAXLONGSUM to exclude maximums.
SHORTSUMM) Short Summary of DB2 activity
/*