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.
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'
If LIST is specified without operands, the default is LIST(CLASS1,CLASS2,BUFFER,LOCKING).
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.
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'
If LONGSUM is specified without operands, the default is LONGSUM(CLASS1,CLASS2,BUFFER,LOCKING).
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 LINECount 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.

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//taildb2.htm