Performance and Tuning for DB2 9
GTS400 Duration: 3 days Cost: $1,000.00 US per student
GTS400 is designed to teach the beginner through advanced DB2 DBAs how to monitor, tune, and troubleshoot DB2 UDB for Linux, UNIX, and Windows. Numerous examples provided for all modules. Courseware: GTS400 Course book, copy of DB2 UDB Handbook V8 for Linux, UNIX, and Windows, IBM Press, Philip K. Gunning, August 2003.
DAY1
DB2 Architecture
DB2 Process Model
Configuration Advisor
Autoconfigure command
Environmental, Registry, and Performance variables
Monitoring and Tuning Configuration Parameters
DAY2
Snapshot Monitoring
-New SQL Snasphot Functions
Creating a snapshot performance repository
Health Monitor
Health Center
Memory Tracker
Memory Visualizer
DB2 Optimizer
-