DB2 LUW Performance Tuning and Monitoring for Single and Multiple Partition DBs (CL443G) – Outline

Outline detalhado do curso

• 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