Home > Data Warehousing > DB2 Data Warehouse Performance & Tuning Workshop

DB2 Data Warehouse Performance & Tuning Workshop

Course Code:	DWHPTW
Platform:	DB2 UDB for LUW
Duration:	4 days
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.
Detailed Outline

Course Schedule