| 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 db2MonitorSwitches - Get/Update Monitor Switches |
| Estimating the size of a snapshot | db2GetSnapshotSize - 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 |
| Resetting monitor counters |
RESET MONITOR db2ResetMonitor - 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 db2MonitorSwitches - Get/Update Monitor Switches |
| Viewing SQL statements |
"SQLCACHE_SNAPSHOT" |
| Writing event monitor values | FLUSH EVENT MONITOR |