Articles & Content

Archives

Physical Database Design for the 21st Century (B08)

Topic: DB2 for z/OS

Subtopic: 2009



DATE: 2009-5-13 (04:00 PM - 05:00 PM)
SPEAKERS: David Simpson (Themis Inc.)

DB2 Versions 8 and 9 introduced some new physical design concepts that may have significant impacts on the way objects should be defined. This presentation explores these new features and examines how they should be used going forward to enable the best possible performance.

EXP. LEVEL: Intermediate

OBJECTIVES:

Be familiar with the tablespace choices in DB2 9.

Understand the effects of index compression.

Be able to design and implement indexes that take advantage of new features.

Be familiar with the statistics that are available, but not collected by default.

Identify the physical design features that enable high performance.



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.