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

DB2 for LUW Database Performance & Tuning

Course Code:	DWUDPT
Currency:	V9 – V9.7
Duration:	4 days
Audience:	System Administrators and Database Administrators.
Prerequisites:	Completion of our course DB2 for LUW 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 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 database and table partitioning How to interpret and use Snapshot and Event Monitors
Detailed Outline

Course Schedule