Summary rules

Summary records contain collected data that is summarized at set intervals (by minute, hour, day, week, month, or year) and saved in the Store database. Data is summarized according to the operation defined for the particular field. These operation definitions are called summary rules.

A field called an additional field might be added to the Store database when data is summarized. Whether an additional field is generated, and the type of the field if generated, depend on the summary rule. Some additional fields are displayed as record fields in PFM - Web Console. These additional fields, which are displayed in PFM - Web Console, can be used in viewing historical reports.

The fields referred to in the record descriptions in this chapter are called record-specific fields, to distinguish them from additional fields generated when data is summarized.

Additional fields have the following field names:

The following table shows the suffix added to the Manager name, the suffix added to the corresponding View name, and the data stored in that field.

Table 5-3 List of suffixes in additional field names

Suffix added to the Manager nameSuffix added to the View nameField data
_TOTAL(Total)Sum of the field values in all records in the summary period
_TOTAL_SEC(Total)Sum of the values of the field in the records collected within the summarization period (when the data type of the field is utime)
_COUNT--Number of records collected in the summary period
_HI(Max)Largest field value in the records in the summary period
_LO(Min)Smallest field value in the records in the summary period
_OV(OV)The number of times that the sum of the values of the field in the records collected within the summarization period overflowed. The value is determined by using the following formula: (sum-of-the-field-values) / (maximum-value-for-the-existing-field + 1) Note: Numbers after the decimal point are discarded.
Legend:
--: No additional field.

The table below lists the summary rules.

Table 5-4 List of summary rules

Summary rule nameSummary rules
COPYStores the actual field value of the most recent record in the summary period.
AVGStores the average field value of all field values in the summary period.
The average value is calculated using the following expression:

(sum-of-field-values)/(number-of-records-collected)

Additional field (Store database)
  • _TOTAL
  • _TOTAL_SEC (when the data type of the field is utime)
  • _COUNT
Additional field (PFM - Web Console)#1, #2
  • (Total)
ADDSum of the field values in all records in the summary period
ADDBIThe lower bytes of the sum of the field values collected within the summarization period are stored in the Store database. The maximum value is extended to 256 times the maximum value in the ADD rule.
The value is determined by using the following formula:(sum-of-the-field-values) % (maximum-value-for-the-existing-field) In the above formula, % indicates that there is a remainder.
Added field (Store database):
  • _OV
Added field (PFM - Web Console) :
  • (OV)
HILargest field value in the records in the summary period
LOSmallest field value in the records in the summary period
--No summarization
#1
For utime type fields whose Manager names contain the character string _AVG, the (Total) fields that are added in Performance Reporter cannot be used for historical reports.
#2
For fields whose Manager names contain any of the following character strings, the (Total) fields that are added in Performance Reporter cannot be used for historical reports:
_PER_, PCT, PERCENT, _AVG, _RATE_TOTAL