Articles & Content


The Power & Pitfalls of Partitioning in V8 9 & Beyond (B01)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-12 (09:45 AM - 10:45 AM)
SPEAKERS: Robert Goodman (Florida Hospital)

DB2 V8, 9 and "X" introduce some powerful partitioning features. Unfortunately, all of the options can lead to confusion. This session will examine six significant partitioning features. It will visually demonstrate the concepts behind each feature and show how they work. Then it will explore when to use the new features by looking at good and bad fits. Finally, it will look at the power and pitfalls in using these features and assess ways they can be implemented to make life better. If you're interesting in understanding and exploiting new partitioning features, this presentation will provide you with some important insights.

EXP. LEVEL: Intermediate,Advanced


Identify six significant partitioning features in V8, 9 and beyond; 1) table based partitioning2) partitionNED vs. partitioNING indexes3) ROTATE table4) universal - partition by growth5) universal - partition by range6) CLONE tables

Demonstrate the concepts behind each of the partitioning features

Explain when the partitioning features are a good or bad fit

Describe implementation options for each feature1) DDL2) Loading 3) Other options

Discuss the power and pitfalls of implementing and supporting partitioning features

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.