Report command

The DB2® report can be requested from a Report Set in the CICS PA dialog. Select the DB2 report in the Subsystem Reports category.

In batch, the DB2 command is used to request the DB2 report.

The command to produce the default report, a short summary showing average values, is:
CICSPA DB2
or
CICSPA DB2(SHORTSUM)
To produce a long summary giving average and maximum values:
CICSPA DB2(LONGSUM)
To produce a detailed listing of all network units-of-work with DB2 activity:
CICSPA DB2(LIST)

To tailor the report, you can specify report options as follows:

CICSPA DB2(
             [OUTPUT(ddname),]
             [EXTERNAL(ddname),]
             [LIST(
                CLASS1,CLASS2,CLASS3,BUFFER,LOCKING,DML1,DML2|ALL),]
             [LONGSUMMARY(
                CLASS1,CLASS2,CLASS3,BUFFER,LOCKING,DML1,DML2|ALL),]
             [SHORTSUMMARY,]
             [SSID(id1,id2,...),]
             [CMFONLY,]
             [LISTZERO,]
             [MAXLONGSUM|NOMAXLONGSUM,]
             [LINECOUNT(nnn),]
             [TITLE1('...sub-heading left ...'),]
             [TITLE2('...sub-heading right...'),]
             [SELECT(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),
                                 ...))])

The report processes all CMF transaction performance class records for network units-of-work containing multiple performance records as well as those with only a single performance record.

You can request a report from all available records, or you can specify selection criteria to request a report from only the records that meet specific requirements.