Home > DB2 UDB for LUW > DB2 Database Performance & Tuning

DB2 Database Performance & Tuning

Course Code:	DWUDPT
Currency:	V8 & V9
Duration:	3 days
Audience:	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
Detailed Outline

Course Schedule