(DI-2202) Collector for DB Triggers

The technical name of the Collector for DB Triggers is /DVD/MON_CL_COL_DB_TRIGGERS.

It collects the details about DB triggers and calculates the number of all valid and invalid DB triggers on the system.

This functionality works only for the following Central database systems:

  • HANA

  • Oracle

  • DB6

  • Adabas/MaxDB

The default KPIs for valid and invalid DB Triggers have assigned a Detail table that contains further details for each DB Trigger.

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

DB_TRIGGER_CNT_ALL

Number of all DB Triggers

number

No

DB_TRIGGER_CNT_INVALID

Number of Invalid DB Triggers

number

Yes

DB_TRIGGER_CNT_VALID

Number of valid DB Triggers

number

Yes

Detail table

The collector provides detailed table DB Trigger details. The technical name of the detail table is /DVD/MON_T_DB_TRIGGER.
DB Trigger details provide a detailed output for each collected DB trigger and contain the following fields:

Technical name

Description

Technical name

Description

TIMESTAMP

When the records are saved into the Detail table

SID

System ID

KPI

KPI name

TRIGGER_NAME

DB Trigger name

SCHEMA_NAME

Schema name

OWNER

Owner name

TABLE_NAME

Table name

ACTION_TIME

Trigger Action time

EVENT_TRIGGER

Event trigger

CREATE_TIME

Created At [TIMESTAMP]

IS_VALID

Is trigger valid?

TRIGGER_DEF

Trigger definition