|
This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance.
Objectives:
After completing this course, students will be able to:
- Use the health monitor, database system monitor, and visual explain to determine database performance
- Improve database performance through configuration parameters and the configuration advisor
- Use the DB2 information center
- Use tracing facilities to understand how to troubleshoot DB2
Topics:
- The health monitor and database system monitor
- The event monitor
- Using visual explain
- Collecting statistics and reorganizing tables
- Controlling the DB2 environment
- The configuration advisor
- The design advisor
- Input/output performance
- The DB2 information center and error-logging facilities
- Tracing facilities
- The ODBC driver manager trace
|
