The new in-memory metrics monitoring infrastructure introduced in Db2 9.7 accesses the monitoring information through new table functions and event monitors. This is an improvement from expensive snapshot-based statistics used in the earlier Db2 releases.
The monitoring table functions and administrative views allow you to capture the state of a database or application connections at a specific point in time, whereas event monitors capture and record information as specific database events occur. The monitoring information collected in both tools is stored in entities called monitor elements. The monitor elements are data structures used to store information about a specific aspect of the database system's status. For example, the monitor element deadlocks reflects the total number of deadlocks that have occurred in the database system since its...