Articles & Content


DB2 Data Warehouse Performance (G01)

Topic: 2006 EU

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2006-10-2 (11:30 - 12:30)
SPEAKERS: David Beulke (Pragmatic Solutions Inc)

DW involves the analysis of data so that data can be transformed into a more valuable asset. Designing and configuring your DW database to handle slow changing dimensions, aggregate totals or non additive data are the next performance hurdles. Through this presentation you will learn how to design your data warehouse to handle these issues and the latest DB2 tuning opportunities for your own effective DW design strategy.

EXP. LEVEL: Advanced


DB2 DW configurations

DB2 DW Design options

Designs to handle SCD and NAD

DSNZPARMS for DW databases

DW sizing considerations

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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