SUMMARY(FIELDS

The Performance Summary report can be tailored by specifying which fields and Application Groups are reported, the order in which they appear in the report, and the statistical functions used to summarize the data. This is done with the FIELDS operand followed by the field names, and for numeric fields, the function(s), and ordering sequence.

Up to 8 sort key fields can be specified, and at least one must be specified. The order of the key fields in the list defines the sort precedence, with the first key field being the major sort field. For each key field, the report can be ordered in ascending (ASCEND) or descending (DESCEND) sequence. The default is ascending. Sort key fields identify the grouping required for summarization, and can be any time stamp field, such as START and STOP time, any Application Group, or any character field, including character user fields.

The sort key fields must be specified first in the list ahead of the numeric fields. The only fields that can appear ahead of a key field are TASKCNT or TASKTCNT.

In addition to the sort key fields, one numeric field can be selected as ascending or descending to activate Alternate Sequencing. This will change the order of report lines from sort key to numeric field sequence. For example, specify RESPONSE(DESCEND) to see the transactions with the highest response time at the top of the report. Note that grouping by sort key remains unaffected by alternate sequencing.

The format of the command is:
TASKCNT and TASKTCNT are special fields that are computed by CICS PA. Specify whether to use TASKCNT or TASKTCNT for the summary statistical calculations. If both are specified, the first one is used in the calculations.

If character type fields are specified in the FIELDS list, they must be specified first (except for TASKCNT or TASKTCNT which can be ahead or amongst them).

All numeric fields (except TASKCNT and TASKTCNT) are summarized using any number of the following statistical functions:

AVE
Average (this is the default if a field is specified without a function).
DEV
Standard deviation.
MAX
Maximum value.
MIN
Minimum value.
TOT
Totals.
SEV
Severity level totals.
nn
nn% peak percentile, for example, 95%. To calculate peak percentiles, CICS PA accumulates the summarized data and then provides a statistical estimate that assumes the data is normally distributed. If the data is not normally distributed, then the peak percentiles will not be accurate: consider using the Range (RNGCOUNT or RNGPERCENT) function to show the exact number or percentage of records that fall within a specified range of values. The Range function provides exact figures that do not assume that the data is normally distributed.
RNGCOUNT(range) or RNGPERCENT(range)
Range. These functions calculate the number of tasks where the value of a field falls within a specified range or matches a single value. RNGCOUNT displays the result as a count; RNGPERCENT displays the result as a percentage of tasks.

The range can be one of:

  • lower limit - upper limit

    For example, RNGCOUNT(0.1-0.2)

    To fall within the range, a field value must be greater than or equal to the lower limit, and less than the upper limit:

    lower limit <= field value < upper limit

  • operator value

    That is, one of the following comparison operators followed by a value:

    = > >= < <=

    For example, RNGPERCENT(<50)

For time fields, values with a decimal place (such as 1.0) are interpreted as seconds; integers (such as 1000) are interpreted as milliseconds.

You cannot use RNGCOUNT or RNGPERCENT to report from an HDB.

Tip: RNGCOUNT and RNGPERCENT generate identical column headings. To distinguish between columns for percentages and counts, check the column values under the headings: percentages appear with a decimal point, whereas counts are integers, and hence have no decimal point.

Here are some example uses of RNGCOUNT and RNGPERCENT:

RESPONSE(RNGCOUNT(<0.9))
Count of tasks with response time less than 0.9 seconds.
RESPONSE(RNGPERCENT(0.5-1.0))
Percentage of tasks with response time >= 0.5 and < 1 seconds.
FCAMCT(RNGCOUNT(>=10))
Count of tasks with 10 or more file access-method requests.
CPU(TIME(RNGCOUNT(>0.5)))
Count of tasks with CPU time greater than 0.5 CPU seconds.
SUSPEND(TIME(RNGCOUNT(>800)))
Count of tasks with suspend time greater than 800 milliseconds (0.8 seconds).
SUSPEND(COUNT(RNGPERCENT(>5)))
Percentage of tasks suspended more than 5 times.
EJBTOTAL(RNGCOUNT(=0))
Count of tasks with no EJB activity.
EJBTOTAL(RNGCOUNT(>0))
Count of tasks with EJB activity.

For performance alert reporting, specify SEV(CRITICAL|WARNING|INFO,COUNT|PERCENT).

Optionally, count values can be converted for reporting by specifying one of the following:

K
Divide value by 1000, typically for count fields
M
Divide value by 1000000, typically for count fields
KB
Kilobytes (divide by 1024), typically for storage fields
MB
Megabytes (divide by 1024x1024), typically for storage fields

If the FIELDS operand is omitted, the default is:

CICSPA SUMMARY(
         FIELDS(TRAN(ASCEND),          Transaction ID
                TASKCNT,               Number of CMF Records
                RESPONSE(AVE,MAX),     Avg/Max Response Time
                DISPATCH,              Avg Dispatch Time
                CPU,                   Avg CPU Time
                SUSPEND(AVE,MAX),      Avg/Max Suspend Time
                DISPWAIT,              Avg Dispatch Wait Time
                FCWAIT,                Avg File Control I/O Wait Time
                FCAMCT,                Avg FC Access Method Calls
                IRWAIT,                Avg Inter-Region I/O Wait Time
                SC24UHWM,              Avg User Storage HWM below 16MB
                SC31UHWM))             Avg User Storage HWM above 16MB
Note:
  1. CPU, DISPATCH, SUSPEND, DISPWAIT, IRWAIT, and FCWAIT are clock type fields. They are allowed to default to TIME(AVE), but equally you could specify CPU(TIME) or CPU(TIME(AVE)), DISPATCH(TIME) or DISPATCH(TIME(AVE)).
  2. Two statistical functions are selected for the RESPONSE field. Specifying FIELDS(RESPONSE(AVE,MAX)) is the same as specifying FIELDS(RESPONSE,RESPONSE(MAX)) or FIELDS(RESPONSE(AVE),RESPONSE(MAX)).

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


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