A piece of information collected by the database system monitor. Snapshot and Event Monitors are the two different interfaces for accessing data elements. Some elements are only accessible with the event monitor (for example, connections involved in a deadlock), and others are only available with snapshot monitoring (for example, data maintained at the database manager level - total number of database agents).
Performance data that is always collected or maintained by the DB2 server, even when all monitor switches are off.
The function of the DB2 database manager that maintains information about its operation and performance.
A function of the DB2 administration GUI for viewing event monitor traces.
Using an event monitor to monitor database activity and performance by obtaining traces of the data collected when specific events occur (for example, the end of a transaction). It is requested from the DB2 server using an SQL interface.
Instructs the DB2 database manager to collect those data elements that involve a non-negligible processing or memory overhead for a group of monitor data.
An object about which the database system monitor can return performance, informational, or status data: for example, the database manager, a database, a connection, or a transaction.
An application using the snapshot API or an event monitor. Each monitoring application has its own logical view of the data collected by the DB2 server. This means that if a monitoring application resets its counters, it does not affect the counters collected by other monitoring applications. The reset API resets counters for snapshot monitoring. Turning off/on an event monitor resets its counters. Counters and switches can only be reset for an event monitor by deactivating and reactivating it.
Using the system monitor API to monitor database activity and performance by sampling the monitor data maintained by the DB2 server. This API consists of:
A function of the Control Center GUI for snapshot monitoring. It provides the ability to follow trends, define performance variables in terms of data elements, and set alerts when thresholds for these variables are reached.