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.