DB2 System Performance and Tuning for LINUX, UNIX and Windows

    

Summary:
This course is designed to review many aspects of performance and tuning of DB2 version 9.7, for Linux, UNIX and Windows (LUW). DB2 commands and tools created by IBM for DB2 will be used to support workshop activities. Performance and tuning varies with type of user to be supported. We will review this topic for support of SQL users, programmers, data designers and database administrators.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for Database Administrators and those senior support persons who are responsible for tuning DB2 for performance.

Topics:

• Creating tables and tablespaces
• Advanced SQL techniques
• SQL performance
• Data Access and EXPLAIN
• The DB2 Optimizer
• Multi-Dimensional Clustering
• Advanced utilities and table design options, including row compression and range partitioning
• Configuring for self tuning of DB2 and automatic maintenance
• Event and snapshot Monitors
• DB2 Operational Model
• The Health and Activity Monitors
• DB2 Configuration Parameters

Prerequisites:
Students should have Relevant Operating Systems experience (LINUX, UNIX or Windows) along with knowledge of relational database theory and SQL. Previous experience of using DB2 in a support role that includes some database administration is also necessary.

Last Update: May 22, 2012