MP9003: Network and Database (General) - Monitoring DB2 Performance > DB2 Universal Database

This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance. 

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

Objectives:
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

Duration:
5 Hours