(DI-2305) Collector for BW Process Chain Steps

This collector monitors BW process chains and their status. The technical name of the Collector for BW process chains is /DVD/MON_BW_CL_COL_ETL_PC.

Default KPIs delivered with this collector

The following default KPIs are delivered with this collector:

KPI name	Description	Unit	Detail table

KPI name	Description	Unit	Detail table
BW_ETL_EXCEEDED_PC	BW: Number of long running Process chains	Number	Yes
BW_ETL_FAILED_PC	BW: Number of failed Process chains	Number	Yes
BW_ETL_FINISHED_PC	BW: Number of successfully finished Process chains	Number	Yes
BW_ETL_RUNNING_PC	BW: Number of running Process chains	Number	Yes

Parameters

The following parameters are used for this collector:

Parameter name	Description

Parameter name	Description
DAYS_BACK_THRESHOLD	How many days to look back when monitoring process chains.

Detail table

The collector provides 2 detail tables Process chain Details and PC Steps Details. The technical name of the detail tables are /DVD/MON_BW_T_PC_DETAIL and /DVD/MON_BW_T_PC_STEP_DET.
BW: Process chain Details reports start, end, and other details of process chains and contain these fields:

Technical name	Description

Technical name	Description
CHAIN_ID	Process Chain
LOG_ID	Log-ID of a Process Chain Run
STARTTIMESTAMP	Process chain start timestamp
ENDTIMESTAMP	Process chain end timestamp
ANALYZED_STATUS	Status of Process
PC_STATUS	Process chain Status
RUNTIME	Process chain runtime [secs]

Second table BW: PC Steps Details provides details about single steps of process chains and contain these fields:

Technical name	Description

Technical name	Description
LOCAL_CHAIN	Sub-chain ID
META_CHAIN	Process Chain
LOG_ID	Log-ID of a Process Chain Run
STARTTIMESTAMP	Process chain start timestamp
ENDTIMESTAMP	Process chain end timestamp
STEP_STATUS	Process chain Step status text
TYPE	Process Type
STATE	Status of Process
VARIANTE	Process Variant (Name)
INSTANCE	Process Instance (Value)
RUNTIME	Process chain runtime [secs]