The Transaction Profiling report compares two sets of CMF performance class data. For example, the performance data for a particular CICS® application in two different time periods, or the performance data for all applications on two systems. The two sets of data to be compared are known as the report data and the baseline data. The Transaction Profiling report can show differences between the report data and baseline data as a "delta" (report data values minus their equivalent baseline data values) or as a percentage change.
To understand how the Transaction Profiling report compares the two sets of data, it is useful to think of the Transaction Profiling report as a consolidated view of two Performance Summary reports: one for the report data and one for the baseline data. CICS PA summarizes the two sets of data separately, then consolidates them by finding a row in the summarized baseline data whose key fields match a row in the summarized report data. CICS PA then compares the values of the non-key fields in the two matched rows. For more information about Performance Summary reports, see Performance Summary report.
You can request the Transaction Profiling report as part of a Report Set, as described here, or you can request the report independently of any Report Set, using option 7 Profiling on the CICS PA Primary Option Menu. The Profiling option offers more flexibility than a Report Set for the source of the report data and baseline data. Using a Report Set, the report data must reside in one or more SMF files and the baseline data must reside in a performance HDB. Using the Profiling option, the report data and baseline data can reside in performance HDBs or SMF files. However, the Profiling option only allows you to request one Transaction Profiling report at a time, while a Report Set allows you to define many Transaction Profiling reports. For more information on the Profiling option, see Requesting a Transaction Profiling report outside a Report Set.
To request the report in a Report Set, enter line action S against the Transaction Profiling Performance Report on the Report Set panel. If reports of this type have been previously specified, the list of Transaction Profiling reports is displayed. Otherwise, the Transaction Profiling Report panel is displayed for you to define your first report of this type.
File Filter Edit Systems Options Help
------------------------------------------------------------------------------
SAMPLE - Transaction Profiling Reports Row 1 from 4
Command ===> ________________________________________________ Scroll ===> ____
---- System Selection ----- Report Selection
/ Exc APPLID + Image + Group + Output Form + HDB + Criteria
S CICSP001 ________ ________ PROF0001 CPUSUM__ HDBP001_ YES
_ DEVT____ MVS1____ ________ PROF0002 CPUSUM__ HDBDEVT_ NO
_ CICST001 ________ ________ PROF0003 TDSUM___ HDBT001_ YES
_ * ________ ________ RSYSGRP1 PROF0004 TDSUM___ HDBGRP1_ NO
******************************* Bottom of data ********************************
This panel displays the list of Transaction Profiling reports in this Report Set. You can select (edit), delete, or include/exclude any report, insert new ones, or rearrange them (move/copy).
The line actions that you can perform are the same as those for the Performance List Reports panel. See Performance List report.
To display the Transaction Profiling Report panel, enter line action S against the Transaction Profiling Performance Report on the Report Set panel, then if the list of previously specified reports is displayed, enter line action S against a particular report in the list.
File Systems Options Help
------------------------------------------------------------------------------
SAMPLE - Transaction Profiling Report
Command ===> _________________________________________________________________
Report System Selection: Report Output:
APPLID . . ________ + DDname . . . . . . . . . PROF0001
Image . . . ________ + Print Lines per Page . . ___ (1-255)
Group . . . ________ +
Baseline Historical Database: ---- Baseline Interval ------
HDB . . . . ________ + YYYY/MM/DD HH:MM:SS.TH
From __________ ___________
To __________ ___________
Report Format:
Report Form . . . ________ + Baseline Form . . ________ +
Title . . ________________________________________________________________
________________________________________________________________
Summary Options: Reporting Options:
Time Interval . . 00:01:00 (hh:mm:ss) Lines . . . . / Report / Baseline
Totals Level . . 8 (blank or 0-8) / Delta / Change
Threshold . . ___ % Above
Selection Criteria: ___ % Below Baseline
_ Performance Exclude . . . _ Within threshold
/ Blank lines
Execution Option:
/ Use External Sort
Repository . . : CICSPA.XYX.REPOSTRY
Use this panel to specify the options of the Transaction Profiling report. The only mandatory options are DDname for the report output and Baseline Historical Database for the source of the baseline data. You can let the other options default.
The precision of numerical fields in the report is specified in Global Options (see Figure 1).
The options are similar to the Performance Summary report, with additional options for Transaction Profiling:
CICS PA assigns a default DDname PROFnnnn where nnnn is a sequential number 0001-9999 to ensure each report has a unique DDname.
This option generates the OUTPUT(ddname) operand.
The current repository is specified in either option 5 Historical Database or option 7 Profiling from the Primary Option Menu.
You specify the Baseline Interval in the same way that you specify the Report Interval when you run the Report Set. For details, see the description of the Start Date/Time, Stop Date/Time option in Set run-time options.
You must have already defined the SUMMARY Report Forms that you want to use. To select the name from a list of SUMMARY Report Forms, position the cursor on the field and press Prompt (F4).
CICS PA JCL generation translates the SUMMARY Report Form specification into the FIELDS operand.
To understand how the Transaction Profiling report uses the Report Form and the Baseline Form, it is useful to think of it as a comparison of two Performance Summary reports. See Transaction Profiling report compares two Performance Summary reports.
Using forms for the Transaction Profiling report involves the following additional considerations to using forms in the Performance Summary report:
For a List HDB Template, the Transaction Profiling report treats all character and date fields as key fields, and uses the average function to summarize the other, non-key, fields. The key fields must precede the non-key fields in the Template: otherwise, CICS PA reports an error.
For a List HDB Template, the Transaction Profiling report treats character and date fields as key fields, and uses the average function to summarize the other, non-key, fields.
Summary HDBs only Data in a Summary HDB is already summarized by the interval that was used to load the data into the HDB. To further summarize the data, specify a multiple of the interval that was used to load the data. If you specify an interval that is equal to or less than the interval used to load the data, the report uses the data as-is, without further summarization.
Specify a value in the range 00:00:01 (1 second) to 24:00:00 (24 hours). The default is 00:01:00 (1 minute).
This option generates the INTERVAL(hh:mm:ss) operand.
Specify 0 for no subtotals, but print only the grand total. This generates the TOTALS(0) operand.
Leave blank if you do not want to include total lines in the report. This generates the NOTOTALS operand.
You can specify either or both of the following thresholds:
For example, a threshold of 150 excludes Change values smaller than +150%.
If you specify a threshold of 0, the report includes all positive Change values.
For example, a threshold of 80 excludes Change values smaller than -80%.
If you specify a threshold of 0, the report includes all negative Change values.
If you omit both thresholds or you specify both thresholds as 0, the report includes all Change values.
If you specify a value for % Above Baseline but you omit % Below Baseline, then the report:
If you specify a value for % Below Baseline but you leave % Above Baseline blank, then the report:
This option generates the THRESHOLD(nnn,nnn) operand.
The Baseline Form can specify a subset of the non-key fields in the Report Form, leaving the summarized baseline data with fewer non-key fields than the summarized report data. Specifying this Exclude within threshold option, together with a Baseline Form that contains only one non-key field, enables you to produce a Transaction Profiling report that only shows data where that field is not within thresholds. For example, if you specify a Baseline Form where the only non-key field is average response time, then you can produce a Transaction Profiling report that shows only the transactions that are not within an acceptable percentage difference of a baseline average response time.
Selecting this option generates the EXCEPTIONSONLY value of the PRINT operand. Otherwise, the PRINT operand specifies FULL (the default value).
Selecting this option generates the NOBLANKLINES value of the PRINT operand (the default value). Otherwise, the PRINT operand specifies BLANKLINES.
CICS PA JCL generation translates these Selection Criteria to identical SELECT(PERFORMANCE operands in the PROFILING(REPORT(...)...) operand and the PROFILING(BASELINE(...)...) operand.
You can also filter report data and baseline data records using different Selection Criteria, by specifying Selection Criteria inside the Report Form or the Baseline Form. Selection Criteria in the Report Form apply only to the report data, even if you do not specify a Baseline Form. Selection Criteria in the Baseline Form apply only to the baseline data.
CICS PA JCL generation translates Selection Criteria in the Report Form to the SELECT2(PERFORMANCE operand in the PROFILING(REPORT(...)...) operand, and Selection Criteria in the Baseline Form to the SELECT2(PERFORMANCE operand in the PROFILING(BASELINE(...)...) operand.
If both the report and a Form specify Selection Criteria, then a record must pass selection by both specifications to be included in the report.