| Monitoring task |
Interface (API, Command, SQL Statement) |
|
|---|---|---|
| Activating an event monitor | SET EVENT MONITOR STATE |
|
| Converting the new monitor datastream | db2ConvMonStream |
|
| Creating an event monitor | CREATE EVENT MONITOR |
|
| Deactivating an event monitor | SET EVENT MONITOR STATE |
|
| Determining the state of an event monitor | "EVENT_MON_STATE" |
|
| Displaying the database manager monitor switches | GET DATABASE MANAGER MONITOR SWITCHES |
|
| Displaying the database system monitor switches |
GET MONITOR SWITCHES sqlmon - Get/Update Monitor Switches |
|
| Estimating the size of a snapshot | sqlmonsz - Estimate Size Required for db2GetSnapshot() Output Buffer |
|
| Formatting the event monitor trace | db2evmon - Event Monitor Productivity Tool |
|
| Listing the active databases | LIST ACTIVE DATABASES |
|
| Listing the applications connected to a database | LIST APPLICATIONS |
|
| Listing the DCS applications | LIST DCS APPLICATIONS |
|
| Removing an event monitor | DROP EVENT MONITOR Command and SQL |
|
| Resetting monitor counters |
RESET MONITOR sqlmrset - Reset Monitor |
|
| Starting the event analyzer | db2eva - Event Analyzer |
|
| Taking a snapshot |
GET SNAPSHOT db2GetSnapshot - Get Snapshot |
|
| Updating the database system monitor switches |
UPDATE MONITOR SWITCHES sqlmon - Get/Update Monitor Switches |
|
| Viewing SQL statements |
"SQLCACHE_SNAPSHOT" |
|
| Writing event monitor values | FLUSH EVENT MONITOR |
|