Enable the stats_triggers trigger group
In the default ObjectServer configuration, the stats_triggers group uses triggers to gather several statistics and metrics. You can enable the trigger group in a production environment.
The triggers in the stats_triggers trigger group count the number of inserts to the alerts.status table, the number of inserts to the alerts.details table, the number of inserts to the alerts.journal table, and the number of deduplications. These counts are stored in the master.activity_stats table and are aggregated by the statistics_gather trigger.
To monitor the number of rows in the
alerts.status table, alerts.details table, and
alerts.journal table, enable the stats_triggers group and the statistics_gather
automation. To enable triggers, use the nco_config command to start
Netcool/OMNIbus Administrator, or use the ALTER TRIGGER GROUP command. The data gathered by this
trigger group and automation is written periodically to the master.stats table. The default interval
is 300 seconds; this value is configurable. The following table describes the column to which the
count of the number of rows is written:
| Table | Column to which the count is written |
|---|---|
alerts.status |
EventCount |
alerts.details |
DetailCount |
alerts.journal |
JournalCount |