Detailed Course Outline
- Database Monitoring
- Database I/O Management
- Table space and Table Design for Performance
- DB2 Memory Management
- Automated Memory Management
- Application Performance Considerations
- Using Explain Tools
- The DB2 Optimizer
- Using Indexes for Performance
- Complex SQL Performance
- Tools and Utilities for Performance
- Event Monitor
- Partitioned Databases Performance Tuning Considerations
- Row Relocation Strategies and FCM Performance Considerations