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