(DI-2211) Collector for DB Triggers
- SNP
The technical name of the Collector for DB Triggers is /DVD/MON_CL_COL_DB_TRIGGERS.
It collects the details about existing DB triggers and calculates the number of all valid and invalid triggers on the system.
This functionality works only for the following Central database systems:
HANA
Oracle
DB6
Adabas/MaxDB
MSSQL
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 |
|---|---|---|---|
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 |
|---|---|
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 |