This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance.
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
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
