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
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Monitor tools
This section lists the tools that DB2 provides for monitoring or analyzing your database.
- Snapshot Monitor, which captures performance information at periodic points of time and is used to determine the current state of the database
- Event Monitor, which provides a summary of activity at the completion of events such as statement execution, transaction completion, or when an application disconnects
- Explain Facility, which provides information about how DB2 accesses the data to resolve the SQL statements
- db2batch tool, which provides performance information as a benchmarking tool
- 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.
- DB2BATCH
A benchmark tool called DB2BATCH is provided in the sqllib/bin subdirectory of your DB2 installation. This tool can read SQL statements from either a flat file or standard input, dynamically describe and prepare the statements, and return an answer set.
Parent topic:
Relational database design and performance tuning for DB2 Database servers