IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers > Monitor tools
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
SNAPSHOT and EVENT monitors
DB2 maintains data as the database manager runs about its operation, its performance, and the applications that are using it. This data can provide important performance and troubleshooting information.
For example, you can track the following developments:
- The number of applications connected to a database, their status, and which SQL statements each application is executing, if any
- Information that shows how well the database manager and database are configured, helping you make tuning decisions
- Information about the time that deadlocks occurred for a specified database, the applications that were involved, and the locks that were in contention
- The list of locks held by an application or a database. If the application cannot proceed because it is waiting for a lock, additional information is on the lock, including which application is holding it.
Collecting performance data introduces some overhead on the operation of the database. DB2 provides monitor switches to control which information is collected. You can use the following DB2 commands to turn on these switches:
UPDATE MONITOR SWITCHES USING BUFFERPOOL ON ; UPDATE MONITOR SWITCHES USING LOCK ON ; UPDATE MONITOR SWITCHES USING SORT ON ; UPDATE MONITOR SWITCHES USING STATEMENT ON ; UPDATE MONITOR SWITCHES USING TABLE ON ; UPDATE MONITOR SWITCHES USING UOW ON ;
You can access the data that the database manager maintains either by taking a snapshot or by using an event monitor.
- SNAPSHOTs
Use the GET SNAPSHOT command to collect status information and format the output for your use. The returned information represents a snapshot of the database manager operational status at the time the command was issued.
Parent topic:
Monitor tools