Snapshot system monitor interfaces
There are a number of system monitor tools that you can use to control the collection of monitor data and review the results.
The following tables show the APIs, CLP commands, and SQL statements available for snapshot system monitor.
| Monitoring task | API |
|---|---|
| Capturing a snapshot | db2GetSnapshot - Get a snapshot of the database manager operational status |
| Converting the self-describing data stream | db2ConvMonStream - Convert the monitor stream to the pre-version 6 format |
| Displaying the database system monitor switches | db2MonitorSwitches - Get or update the monitor switch settings |
| Estimating the size of a snapshot | db2GetSnapshotSize - Estimate the output buffer size required for the db2GetSnapshot API |
| Get/update monitor switches | db2MonitorSwitches - Get or update the monitor switch settings |
| Resetting monitor counters | db2ResetMonitor - Reset the database system monitor data |
| Updating the database system monitor switches | db2MonitorSwitches - Get or update the monitor switch settings |
| Monitoring task | CLP Command |
|---|---|
| Capturing a snapshot | GET SNAPSHOT |
| Displaying the database manager monitor switches | GET DATABASE MANAGER MONITOR SWITCHES |
| Displaying the monitoring application's monitor switches | GET MONITOR SWITCHES |
| Formatting the event monitor trace | db2evmon - Event monitor productivity tool |
| Generating sample SQL for write-to-table CREATE EVENT MONITOR statements | db2evtbl - Generate event monitor target table definitions |
| Listing the active databases | LIST ACTIVE DATABASES |
| Listing the applications connected to a database | LIST APPLICATIONS |
| Listing the DCS applications | LIST DCS APPLICATIONS |
| Resetting monitor counters | RESET MONITOR |
| Updating the database system monitor switches | UPDATE MONITOR SWITCHES |
| Monitoring task | SQL Statement |
|---|---|
| Activating an event monitor | SET EVENT MONITOR STATE |
| Creating an event monitor | CREATE EVENT MONITOR |
| Deactivating an event monitor | SET EVENT MONITOR STATE |
| Removing an event monitor | DROP |
| Writing event monitor values | FLUSH EVENT MONITOR |