Online training in the virtual classroom
E-Learning offers and more

Find out more

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

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