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:
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.
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.
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.
A global value can be specified to apply to all reports. If a value is also specified here on the report panel, it takes precedence over the global for this report only.
CICS PA JCL generation translates this field to the LINECount 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.
If you omit key fields from the Baseline Form that appear in the Report Form, then the Transaction Profiling report matches rows in the two sets of summarized data based on their common key fields. The typical effect is that several rows of summarized report data (with more key fields) match one row of baseline data.
If the Baseline Form omits some of the non-key fields specified by the Report Form, then the Transaction Profiling report shows blanks for these missing fields in the Baseline, Delta, and Change lines.
If the report uses a Report Form, and a title is specified on both, the title on this report panel takes precedence.
This option generates the TITLE1('left-half') and TITLE2('right-half') operands.
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).
A time interval of less than one hour must fit evenly into the hour. CICS PA will round it down to the nearest interval that aligns to the hour. For example, 1.35 is reduced to 00:01:30 minutes which will produce 40 interval report lines for each hour of data.
A time interval of more than one hour must fit evenly into the day. CICS PA will round it down to the nearest interval that aligns to the day. For example, 10.30.23 is reduced to 08:00:00 hours which will produce 3 interval report lines for each day of data.
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.
Report 1.0 0.1
Baseline 0.4 0.5
Change% +150.00 -80.00
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.
Select / to use an external sort utility to process summary records. This is the default. It generates the EXTERNAL(ddname) operand. This provides the DDname of the work data set used by the external sort utility. CICS PA assigns an External Work File from a pool of External Work Files with default DDnames in the format CPAXWnnn where nnn is a sequential number 001-999 to uniquely identify the work file.
An external sort should be used when processing large volumes of data.
If not selected, an internal sort is used.