DB2 Version 9.7 for Linux, UNIX, and Windows

num_threshold_violations - Number of threshold violations monitor element

The number of threshold violations that have taken place in this database since it was last activated. This monitor element is an alias of the thresh_violations - Number of threshold violations monitor element monitor element, which is returned by some monitoring (MON_*) table functions.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-

Usage

This element can be used to help determine whether or not thresholds are effective for this particular application or whether the threshold violations are excessive.