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.
|
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.
|
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)
|
|
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.
|
|
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