Articles & Content


DB2 for z/OS DB2 Database Design - Top Tips from Experience (A04)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-5-19 (04:00 PM - 05:00 PM)
SPEAKERS: Randy Ebersole (IBM DB2 for z/OS Lab Services)

A good database design is part science, part experience and is the foundation on delivering a high performance and highly available DB2 application. This session will discuss areas that Randy has seen as the most important to focus on and deliver based on his involvement in more than 200 DB2 database/application designs. We will discuss various real life scenarios in this session and provide suggestions on how to best deliver the design based on the performance and availability requirements.

EXP. LEVEL: Intermediate


index design


number Generation

batch processing

two tables or One table - Context design-Surrogate or business keys-DB2 RI

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.