(DI-2205) Collector for Calculation

The collector for calculation is /DVD/MON_CA_CL_COL_CALC.

The collector collects KPIs with a defined calculation function in the Input table. The KPIs are defined through KPI definition and the Input table /DVD/MON_CA_KDEF.

The Input table /DVD/MON_CA_KDEF sets up the calculation function for a KPI. The Input table contains the following fields:

KPI name	The same technical name as in the KPI definition
Function	Calculation function
Changed by	Last change by user [automatically filled]
Changed at	Last change date and time [automatically filled]
Created by	Created by user [automatically filled]
Created at	Created date and time [automatically filled]

Functions for calculations

KPI() – Function KPI() returns collected values of KPI in a time range.

Parameters: only one KPI

AVG() – Calculates the average of values.

MAX() – Selects the maximum value.

MIN() – Selects the minimum value.

SUM() – Function sum of all values.

DIFF() – Function subtract for all values.

MUL() – Multiplication of all values.

DIV() – Dividing values.

Parameters for functions above:

only one KPI
more constant values
more functions
combination of constants and functions

Examples

KPI(DB_CPU_LOAD5_P) – returns all values in a time range

MAX(KPI(DB_CPU_LOAD5_P)) – gets maximum of values from KPI

MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60) – gets maximum of two values,

- the first parameter is MAX(KPI(DB_CPU_LOAD5_P))

- and second is the threshold – 60

DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60), 60) – divides maximum from

- function MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60)

- and threshold – 60

Example of an Input table

KPI name	Function
CF_THRESHOLD	DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 90), 90)
ZCALC_FUNCTION	MAX(KPI(CPU_IDLE))

This KPI is provided in the CrystalBridge® Monitoring delivery with this collector:

KPI name	Description	Unit
CF_THRESHOLD	Value relative to the threshold of a KPI	Count