Articles & Content


Table and Index Design Strategies in DB2 9 and 10 (A05)

Topic: 2011 NA

Subtopic: DB2 for z/OS

DATE: 2011-5-4 (08:30 AM - 09:30 AM)
SPEAKERS: Susan Lawson (YLA)

This presentation takes a look at table and index design strategies we have practiced over the years and see how they are impacted by DB2 9 and 10. We also look at how we can move forward with current designs and also be able to take advantage of the advanced features of DB2 9 and 10.Availability, Scalability and Performance

EXP. LEVEL: Intermediate


Discuss overall objectives of DB2 9 and 10 table and index features

Discuss current design limitations and issues

Look at the pros and cons of utilizing the new features in 9 and 10

Discuss how we will move forward with current designs

Discuss what we still need to consider for optimal designs strategies

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.