DB2 report
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.
- For CMF records: by APPLID/transaction/program
- For DB2 records: by APPLID/transaction/program/SSID/plan
- 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.
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.
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.
- CICS System Selection
- Identifies the CICS APPLIDs 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 subsystems
must be those used by the specified CICS systems,
otherwise they are ignored by DB2 report
processing. If you do not specify a DB2 System Selection then the DB2 SSIDs are obtained as follows:
- 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 subsystems for the CICS systems 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:
- ⁄
- Display the menu of line actions.
- S
- 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.