DB2 - DB2 report
The DB2® operand requests the DB2 report.
Note: To maximize the DB2 details
available for reporting, define your CICS-DB2 resources with ACCOUNTREC(TASK)
or ACCOUNTREC(UOW). See the CICS DB2 Guide for more information
on accounting for DB2 resources
and the setup required.
The command format is:
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 options are:
- OUTPUT
- Controls the report output DDname. If not specified, CICS PA assigns a DDname in the format DB2Rnnnn where nnnn is the report sequence number 0001-9999. See OUTPUT for further information.
- EXTERNAL
- Specifies the DDname for the work data set used by the external sort facility. If not specified, CICS PA assigns an External Work File from a pool of External Work Files with DDnames in the format CPAXWnnn where nnn is the sequence number 001-999. See EXTERNAL for further information.
- LIST
- Requests the DB2 List report, a detailed list of all network
units-of-work with DB2 activity.
This report consolidates CICS® CMF
performance class records and DB2 accounting
statistics from a single or multiple CICS systems.
Each line on the report is a single CMF performance or DB2 accounting record. Specify one or more of the following operands (or ALL) to control which DB2 accounting details are to be reported.If LIST is specified without operands, the default is LIST(CLASS1,CLASS2,BUFFER,LOCKING).Note: Thread Identification is always reported.
- CLASS1
- Thread Time
- CLASS2
- In-DB2 Time
- CLASS3
- Suspend Time
- BUFFER
- Buffer Manager Summary
- LOCKING
- Locking Summary
- DML1
- SQL DML Query/Update
- DML2
- SQL DML 'Other'
- LONGSUMmary
- Requests the DB2 Long Summary report which summarizes these
details by transaction and program (CMF performance data) and SSID
and plan (DB2 accounting data)
within APPLID. For each, average and maximum values are reported.
CMF performance data is presented in columns across the page and associated DB2 accounting data is presented
in rows down the page. Specify one or more of the following operands (or ALL) to control which of the DB2 accounting details to include in the report.If LONGSUM is specified without operands, the default is LONGSUM(CLASS1,CLASS2,BUFFER,LOCKING).Note: Thread Utilization is always reported.
- CLASS1
- Thread Time
- CLASS2
- In-DB2 Time
- CLASS3
- Suspend Time
- BUFFER
- Buffer Manager Summary
- LOCKING
- Locking Summary
- DML1
- SQL DML Query/Update
- DML2
- SQL DML 'Other'
- SHORTSUMmary
- Requests the DB2 Short Summary report, an abridged version of the DB2 Long Summary report, giving averages only (no maximums). This is the default report.
- SSID
- Requests reporting to be limited to the DB2 Subsystem IDs that match the specified IDs or patterns. Masking characters are supported: % for one and only one character, and * for many or none.
- CMFONLY
- Requests CICS PA to process only CMF performance (SMF 110) records and not DB2 accounting records. If not specified, CICS PA will also process associated DB2 accounting (SMF 101) records. The default is to process both.
- LISTZERO
- Applies to the DB2 List report. Specify this option to report CMF performance records with DB2REQCT=0 provided they are part of a network unit-of-work that has some DB2 activity. The default is to omit the CMF performance records with no DB2 activity.
- MAXLONGSUM|NOMAXLONGSUM
- Applies to the DB2 Long
Summary report.
MAXLONGSUM requests that both average and maximum values are to be reported in the DB2 accounting detail lines. This is the default.
NOMAXLONGSUM requests that only the averages are to be reported (maximum values omitted).
- LINECount
- Controls the number of lines per page. See LINECNT for further information.
- TITLE1, TITLE2
- Controls the report title (left and right half of subheading line). See TITLE1 and TITLE2 for further information.
- SELECT(PERFORMANCE(INCLUDE|EXCLUDE
- Specifies what data to include or exclude from the report based on data field values. See Using SELECT statements for a detailed explanation and examples.