DB2 Database Performance Tuning

Currency:V8 & V9Audience:System Administrators and Database Administrators.Prerequisites:Completion of our course Database Administration or equivalent knowledge.Summary:This presentation is designed to help Database Administrators to optimally design, size, implement, maintain, monitor and tune the RDBMS for the Linux/UNIX/Windows environment.Objectives:Upon completion of this presentation, the participant should understand the following as they relate to the optimal performance of IBM DB2 UDB database for LUW:

• How to organise and implement performance, monitoring and tuning
• How to optimally size the RDBMS
• How to determine server requirements
• How to optimise the disk subsystem
• How to optimise physical database design
• How to optimise the use of utilities
• How to optimise SQL
• How to optimise the use of multi-dimensional clustering (MDC) tables