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.
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.
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.
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.
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.
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).
If not selected, then the CMFONLY operand is generated, and CICS PA just reports the DB2 statistics contained in the CMF performance records.
Not selected is the default.
If not selected, the NOMAXLONGSUM operand is generated and only the averages are reported.