Articles & Content
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.