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.

The DB2 List report shows detailed information of DB2 activity for each transaction. The DB2 Summary reports summarize DB2 activity by transaction:
The reports include the following DB2 information:

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 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.
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 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.

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/pdb2r.htm