The DB2® report processes CICS® CMF performance class (SMF
110) records and DB2 accounting
(SMF 101) records to produce a consolidated and detailed view of DB2 usage by your CICS systems. The DB2 report
enables you to view CICS and DB2 resource usage statistics together
in a single report.
The DB2 report matches CMF
Performance records with DB2 accounting
records by network unit-of-work id. Your CICS-DB2 resources must be
defined with ACCOUNTREC(TASK) or ACCOUNTREC(UOW) for
matching to occur.
The DB2 List report shows
detailed information of DB2 activity
for each transaction. The DB2 Summary
reports summarize DB2 activity
by transaction:
- For CMF records: by APPLID/transaction/program
- For DB2 records: by APPLID/transaction/program/SSID/plan
The reports include the following DB2 information:
- DB2 Thread Identification,
for easy cross-reference to DB2 PM
- Class 1 Thread elapsed and CPU times
- Class 2 In-DB2 elapsed and CPU times
- Class 3 Suspend times
- Buffer Manager statistics
- Locking statistics
- SQL DML statistics
A Recap report showing processing statistics is always printed
at the end.
To request the DB2 report,
enter line action
S against the
DB2 Subsystem Report on the Report Set panel.
If reports of this type have been previously specified, the list of DB2 Reports is displayed. Otherwise,
the DB2 Report panel is displayed
for you to define your first report of this type.
Figure 1. DB2 Reports File Filter Edit Systems Options Help
------------------------------------------------------------------------------
SAMPLE - DB2 Reports Row 1 from 4
Command ===> ________________________________________________ Scroll ===> ____
---- System Selection ----- Selection
/ Exc APPLID + Image + Group + Output Criteria
_ CICSP001 ________ ________ DB2R0001 YES
_ DEVT____ MVS1____ ________ DB2R0002 NO
_ CICST001 ________ ________ DB2R0003 YES
_ * ________ ________ RSYSGRP1 DB2R0004 NO
********************************* End of list *********************************
This panel displays the list of DB2 Reports
in this Report Set. You can select (edit), delete, or include/exclude
any report, insert new ones, or rearrange them (move/copy).
The options are the same as those for the Performance List Reports
panel, except there is no Report Form. See Performance List report.
The line actions are the same as on similar Reports list panels.
See page Performance List report.
Enter line action
S to select a report in the list.
Figure 2. DB2 Report File Systems Options Help
------------------------------------------------------------------------------
SAMPLE - DB2 Report
Command ===> _________________________________________________________________
CICS System Selection: Report Output:
APPLID . . CICSP001 + DDname . . . . . . . . . DB2R0001
Image . . ________ + Print Lines per Page . . ___ (1-255)
Group . . ________ +
DB2 System Selection: Report Options:
SSID . . . DB2P + / Process DB2 Accounting records
Image . . ________ + _ List records with no DB2 activity
Group . . ________ + / Long Summary with DB2 maximums
Reports ----- DB2 Accounting data to include in report ------
Required: Class1 Class2 Class3 Buffer Locking DML 1 DML 2
_ List / / _ / / _ _
_ Long Summary / / _ / / _ _
/ Short Summary
Report Format:
Title . . ________________________________________________________________
________________________________________________________________
Selection Criteria:
_ Performance *
F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions
F12=Cancel
Use this panel to specify report options and record selection criteria
for the DB2 report. The only
mandatory option is the Report Output DDname. You can let the other
options default.
The options are:
- CICS System Selection
- Identifies the CICS APPLID(s) whose data you want to select
for processing.
You can specify any combination of APPLID, Image,
or Group, but these must be defined in your System Definitions. If
you do not specify System Selection here or in the Global Options,
then you are prompted at run time to specify the System Selection.
This will apply globally to all reports and extracts without their
own System Selection. This is recommended as it allows you to run
your Report Sets against any of your defined Systems. Press the Prompt key
(F4) to select from a list of defined Systems, Images, or Groups.
To modify your System Definitions, select Systems in the
action bar.
Specify one of the following:
- A CICS APPLID. An APPLID that matches a defined
System's name pattern is also allowed. For example, CICSP1 can be
specified if CICSP* is a defined system.
- An APPLID and an MVS™ Image. This identifies the MVS Image
where your CICS system runs.
- An MVS Image. All CICS systems
executing on this MVS Image is selected.
- An APPLID and Image combination plus a Group. This is useful for
uniquely identifying a CICS system when there are multiple CICS systems
with the same name defined.
- A Group alone. CICS PA
will select all CICS APPLIDs defined to the Group. For example,
for transaction grouping, or for systems that connect via IRC/MRO,
ISC/APPC, or IPIC.
CICS PA uses
the System Selection in JCL generation to build the APPLID(applid1,applid2,applid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands,
and corresponding //SMFINnnn DD statements.
System
Selection can also be specified either:
- In Global Options. The report-level specification takes precedence
over the global.
- At run time. The run-time System Selection overrides the Global
Options and optionally the report-level specification.
- DB2 System Selection
- DB2 System Selection identifies
the DB2 subsystems that you
want to report against. The DB2 subsystem(s)
must be those used by the specified CICS systems,
otherwise they are ignored by DB2 report
processing.
You do not need to specify a DB2 System Selection. If you don't, then the
following will occur:
- When the CICS System Definition
specifies a Group that contains DB2 SSIDs,
then CICS PA uses
the DB2 SSIDs defined to the
Group.
- Otherwise CICS PA assumes
that the DB2 Accounting records
are contained in the same file as the CICS system's
CMF records, and will automatically determine the correct DB2 subsystem(s) for the CICS system(s) to be reported.
Any combination of SSID, Image, or Group can be specified
but must be defined in your System Definitions. Use Prompt (F4)
to select from a list of defined Systems, Images or Groups. To modify
your System Definitions, select Systems in the action bar.
CICS PA uses
the DB2 System Selection in
JCL generation to build the SSID(ssid1,ssid2,ssid3,...) operand.
- Report Output DDname
- The DDname for the report output which CICS PA uses
when generating the JCL to run the Report Set. The DDname is mandatory
and should be unique to separate the output of multiple reports.
CICS PA assigns
a default DDname DB2Rnnnn where nnnn is a sequential number 0001-9999 to
ensure each report has a unique DDname.
This option generates
the OUTPUT(ddname) operand.
- Print Lines per Page
- The maximum number of lines, including headings, to print on each
page of the report. Valid values are from 1 to 255. The default is 60.
The
global value applies to all reports. If a value is specified on this
report panel, the report value takes precedence over the global for
this report only.
CICS PA JCL
generation translates this field to the LINECount(nnn) operand.
- Reports Required
- Enter / to select the reports you want produced. The Recap
report is always produced at the end to provide processing statistics.
- Select List to request the DB2 List
report, a detailed list of all network units-of-work with DB2 activity, consolidating CMF
performance class records and DB2 accounting
data. This selection generates the LIST operand.
- Select Long Summary to request the DB2 Long Summary report which summarizes these
details by transaction and program within APPLID, giving average and
maximum values for each. This selection generates the LONGSUM operand.
- Select Short Summary to request the DB2 Short Summary report which is an abridged
version of the Long Summary report with significantly less detail
and averages only (no maximums). This selection generates the SHORTSUM operand
and is the default.
- DB2 Accounting data to include
in reports
- This option applies to the DB2 List
and Long Summary reports, and then only if Process DB2 Accounting records is selected.
Enter
/ to
select the DB2 detail lines
to include in each report:
- Class1
- Thread Time (default)
- Class2
- In-DB2 Time (default)
- Class3
- Suspend Time
- Buffer
- Buffer Manager Summary (default)
- Locking
- Locking Summary (default)
- DML 1
- SQL DML Query/Update
- DML 2
- SQL DML 'Other'
The default is to include
Class1, Class2,
Buffer, and
Locking. Note: Thread Identification is always
reported.
If the List report is selected, JCL generation
translates this option to LIST(CLASS1,CLASS2,CLASS3,BUFFER,LOCKING,DML1,DML2).
If
the LongSummary report is selected, JCL generation translates this
option to LONGSUM(CLASS1,CLASS2,CLASS3,BUFFER,LOCKING,DML1,DML2).
- Report Options
- The DB2 Report processes
all CMF performance data records that are within a network unit-of-work
that involves some DB2 activity.
You can control the amount of processing and volume of output by restricting
the data that is reported.
Enter
/ to select the type of
data to include in the report:
- Process DB2 Accounting records
- Select this option for CICS PA to process DB2 Accounting (SMF 101) records.
Selected is the default.
If not selected, then the CMFONLY operand
is generated, and CICS PA just
reports the DB2 statistics contained
in the CMF performance records.
- List records with no DB2 activity
- This option only applies to the DB2 List
report. Select 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. If selected,
the LISTZERO operand is generated.
Not selected
is the default.
- Long Summary with DB2 maximums
- Select this option to include maximum values in the DB2 Accounting detail lines of the Long Summary
report. If selected, the MAXLONGSUM operand is generated
and both average and maximum values are reported. Selected is the
default.
If not selected, the NOMAXLONGSUM operand
is generated and only the averages are reported.
- Title
- Title of the report. Specify up to 128 characters of text to describe
the report. CICS PA concatenates
the two lines of 64 exactly as entered to make one line which prints
at the top of each page of the report below the heading. The default
is blank (no title).
This option generates the TITLE1('left-half') and TITLE2('right-half') operands.
- Performance Selection Criteria
- For
information on how the Selection Criteria applies to the DB2 Accounting records, see Selecting DB2 accounting records.
Line Actions:
Valid line actions are:- ⁄
- Display the menu of line actions.
- S
- Select to display the subpanel where Selection Criteria can be
specified for this report. For details, see Specifying Selection Criteria.
- A
- Activate the Selection Criteria so they are generated for this
report when the Report Set is submitted. Selection Criteria can only
be activated if one or more Select Statements are specified and not
all are excluded. An asterisk * indicates they are active.
- D
- Deactivate the Selection Criteria. Any you have specified here
will not be used.