DB2 Data Warehouse Performance & Tuning Workshop

Platform:
DB2 for LUW

Audience:
DB2 BI and data warehouse developers, database administrators and system administrators.

Prerequisites:
Completion of our course DB2 Data Warehouse Fundamentals or equivalent knowledge.

Summary:
This presentation and hands-on workshop emphasises how to optimise data warehouse design in both non-partitioned and partitioned environments. Topics central to this presentation include:

• Giga- and Tera-byte table considerations
• Partitioning and parallelism
• I/O design
• High performance
• DB/DBM configuration parameters
• How to exploit the DB2 optimizer
• Materialized Views/Materialized Query Tables (MQTs)
• Multidimensional Clustering (MDC)

Objectives:
Upon completion of this course, the participant should be able to to design, optimise and implement large-scale data warehouses to meet a variety of BI (Business Intelligence).

Format:
Lecture and hands-on.