CPADB2 - DB2 report

This JCL runs the CICS PA 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
/*