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

Esquema Detallado del 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