Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference


Summary rules

For records of the PI record type, two types of data are stored in the Store database: The data collected at the interval set in Collection Interval, and the data summarized for a specific period of time (minute, hour, day, week, month, or year) according to a predefined rule. The type of summarization is defined for each field. This definition is called a summarization rule.

Depending on the summarization rule, intermediate data in the summarization period must be retained. In this case, a field for holding the intermediate data is added to a record in the Store database. This field is called an added field.

Part of an added field is displayed as a record field in PFM - Web Console. The added fields displayed on PFM - Web Console can be used as the fields to be displayed in a historical report.

The fields referred to in the record descriptions in this chapter are known as 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 PFM - Manager name, the suffix added to the corresponding PFM - View name, and the data stored in that field.

Table 5‒3: List of suffixes in additional field names

Suffix added to the PFM - Manager name

Suffix added to the PFM - View name

Field data

_TOTAL

(Total)

Sum of the field values in all records in the summary period

_COUNT

--

Number of records collected in the summary period

_HI

(Max)

Highest field value in the records in the summary period

_LO

(Min)

Lowest field value in the records in the summary period

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

  • _COUNT

Additional field (PFM - Web Console)

  • (Total)

HILO

Stores the highest value, lowest value, and average value of all field values in the summary period.

A record-specific field stores the average value.

The highest value, lowest value, and average value is calculated using the following expression:

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

Additional field (Store database)

  • _HI

  • _LO

  • _TOTAL

  • _COUNT

Additional field (PFM - Web Console)

  • (Max)

  • (Min)

  • (Total)

--

No summarization