(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]