Answer» - ACTIVITIES: Records activity events that occur as the database is used.
- BUFFERPOOLS: Records a buffer pool event when the last application disconnects from the database.
- CONNECTIONS: Records a connection event when an application disconnects from the database.
- DATABASE: Records a database event when the last application disconnects from the database.
- DEADLOCKS: Records a deadlock event whenever a deadlock occurs. However, this monitor is depreciated and the LOCKING event should be used instead.
- DEADLOCKS WITH DETAILS
- DEADLOCKS WITH DETAILS HISTORY
- DEADLOCKS WITH DETAILS HISTORY VALUES
- STATEMENTS: Records a STATEMENT event whenever a SQL statement finishes running.
- STATISTICS: Record statistics events that occur when USING the database.
- TABLES: Records a tabled event for each active table when the last application disconnects from the database.
- TABLESPACES: Records a tablespace event for each tablespace when the last application disconnects from the database.
- THRESHOLD VIOLATIONS: Records threshold violation events that occur when using the database.
- TRANSACTIONS: Records a transaction event whenever a transaction completes.
- UNIT OF WORK: Records events when a unit of work completes.
- LOCKING: Records a lock event whenever a lock-related event occurs, such as lock TIMEOUT, lock waits, and deadlocks.
- PACKAGE CACHE: Records events related to the package cache statement.
- CHANGE HISTORY: Records events related to changes to the DB CFG, DBM CFG, and DB2 registry settings, track the execution of utilities such as LOAD, online backup, REORG, and RUNSTATS.
|
