Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2008



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

OBJECTIVES:

index design

partitioning

number Generation

batch processing

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



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.