Articles & Content


DB2 for z/OS Data Warehouse Performance (C15)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-15 (12:30 PM - 01:30 PM)
SPEAKERS: Robert Catterall (Catterall Consulting)

When DB2 debuted on IBM's mainframe server line in 1983, it was positioned as a technologically innovative base for decision support applications. Over the years, DB2's OLTP performance improved dramatically, and run-the-business applications built on DB2 proliferated. The past couple of years has seen a resurgence in data warehouse activity on the DB2 for z/OS platform, coinciding with the delivery of modern BI-benefitting features such as materialized query tables, star join, recursive SQL, 64-bit addressing, and zIIP engine exploitation. This session will describe the strengths of DB2 for z/OS as a foundation for data warehousing, compare performance management in DB2 data warehouse versus OLTP environments, and provide recomemndations for system- and statement-level performance tuning for DB2-based BI applications.

EXP. LEVEL: Beginner,Intermediate,Advanced


The technology that is fueling the renewed popularity of DB2 for z/OS as a data-serving foundation for data warehouse applications.

Two different DB2 performance management perspectives: OLTP versus data warehouse.

System-level DB2 data warehouse performance optimization.

Logical and physical database design for a mainframe DB2-based data warehouse.

SQL statement performance analysis and tuning in a DB2 for z/OS business intelligence environment.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.