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:

Additional field contained in the Store database

Manager name of the record-specific field, plus a suffix
Additional field displayed in PFM - Web Console

View name of the record-specific field, plus a suffix

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 name	Suffix added to the View name	Field 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 name	Summary rules
COPY	Stores the actual field value of the most recent record in the summary period.
AVG	Stores the average field value of all field values in the summary period. The average value is calculated using the following expression: `(total-sum-of-the-field-values)/(number-of-collected-records)` 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)
ADD	Sum of the field values in all records in the summary period
ADDBI	The 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)
HI	Largest field value in the records in the summary period
LO	Smallest 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

To Page Top