HDB Reporting

The HDB(REPORT) operand requests CICS PA to generate reports from performance HDB data.

The command format is:
CICSPA HDB(REPORT(hdbname),
          [OUTPUT(ddname),]
          [NOTOTALS|TOTALS(n),]
          [SUFACTOR(hdbname(nnnnn.nnn)),]
          [INTERVAL(hh:mm:ss),]
          [FIELDS(field1[(options)],...),]
          [LINECount(nnn),]
          [SELECT(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...)),]
          [SELECT2(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...))])
The options are:
REPORT
Specifies the name of the performance HDB to report against. The HDB must be defined in the Repository (DDname CPAHDBRG).
OUTPUT
Report output file name. See OUTPUT for further information. If not specified, CICS PA assigns a DDname in the format HDBRnnnn where nnnn is the report sequence number 0001-9999 to uniquely identify the output.
NOTOTALS|TOTALS(n)
The totals level applies only to the Summary report.

Specify TOTALS(1) to TOTALS(8) to accumulate subtotals for up to 8 sort fields, print the subtotals when the sort field changes, and print a grand total at the end of the report. Default: TOTALS(8)

Specify TOTALS(0) for no subtotals, but print only the grand total.

Specify NOTOTALS for neither subtotals nor grand total.

SUFACTOR
Specifies a CPU SU conversion factor to apply to the HDB container. The SUFACTOR operand includes two keywords to identify the HDB name and its associated conversion factor. The value must be a decimal number or integer in the range 1 - 999999999 (nine 9s).

When reporting or extracting HDB records the CPU SU conversion factor will only be applied when field CPUSU is not present in the HDB record. In other words, if field CPUSU is in the HDB record, it will be reported as is, otherwise, it will be calculated using the CPU SU conversion factor.

INTERVAL
This operand applies to Summary HDBs. It specifies a time interval when the report summarizes transaction activity over time. The interval is in the range 1 second to 24 hours in the format hh:mm:ss for hours, minutes, and seconds.

Data in a Summary HDB is already summarized by the interval that was used to load the data. This is the value specified in the HDB or, if Time Interval was not specified in the HDB, the value defined in the Template.

You can further summarize the data by specifying a multiple of the interval that was used to load the data. Specify a value in the range 00:00:01 (1 second) to 24:00:00 (24 hours). For example, specify 00:15:00 if you want to summarize transaction activity over 15 minute intervals. If you are reviewing many days worth of data then you might specify 24:00:00 (24 hours) so that you can view the daily trend.

Notes:
  • If you specify a reporting interval that is equal to or less than the interval that was used to load the data, the report or extract uses the data as-is, without further summarization.
  • If you do not specify a reporting interval it defaults to the interval that was used to load the data, unless that value is less than 1 minute, in which case the reporting interval is set to 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.

Minutes take precedence for an abbreviated entry. For example:
1
becomes 00:01:00
1.1
becomes 00:01:00 (rounded down from 00:01:01)
1.1.1
becomes 01:00:00 (rounded down from 01:01:01)
FIELDS
Specifies which fields are reported, the order in which they appear in the report, and their summarization presentation. Only fields that are specified in the HDB Template can be specified. Fields not contained in the HDB are reported as Missing.

When reporting from a Summary HDB, the options for specifying fields are similar to the options for a Performance Summary report. For details, seeSUMMARY(FIELDS.

When reporting from a List HDB, the options for specifying fields are similar to the options for a Performance List report. For details, seeLIST(FIELDS.

LINECount
Controls the number of lines per page in the HDB report. See LINECNT for further information.
SELECT, SELECT2
These statements specify what data to include or exclude from the report based on data field values. See Using SELECT statements for an explanation and examples.

Start of changeYou can use both SELECT and SELECT2 to perform record filtering. The CICS PA dialog generates SELECT2 statements in the JCL when you use a report form that has active selection criteria. You can add a SELECT statement by editing the generated JCL. If both SELECT and SELECT2 are specified, the record must pass selection by both specifications for it to be included in the report.End of change

Start of changeThe following restrictions apply to selection criteria.End of change

Start of change
  • The SELECT and SELECT2 options can specify only fields that are contained in the HDB. If the selection criteria specify a field that is not present, the report returns an error that identifies the field.
  • For a performance summary report, as distinct from a performance list report, CICS PA ignores selection criteria for summarized fields because it would be meaningless to apply selection criteria to them. However, you can apply selection criteria for key fields, that is character and time stamp fields.
End of change