Articles & Content

Archives

Physical Database Design for DB2 on z/OS (C04)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-12 (02:45 PM - 03:45 PM)
SPEAKERS: Jim Teng (IBM Silicon Valley Lab)

Learn how to exploit features on different types of table spaces and indexes for physical database design. This presentation will review the characteristics and benefits of different types of table space and index structures in DB2 V8 and V9. This will help database administrators to decide table space and index structures for physical database design based on application's performance and availability requirements. This session will also provide hints and tips on certain table space and index attributes that may help to improve insert performance.

EXP. LEVEL: Intermediate

OBJECTIVES:

DB2 Database Physical Organization: Database, Table/Index Spaces, Storage Groups, VSAM data sets

Different Types of Table Spaces: Segmented, Partitioned, Member Cluster, Universal, LOB

Different Types of Indexes: PI, NPI, DPSI, Index Compression, Index on Expression

Hints and Tips to improve Insert Performance

Automatic Creation of DB2 Objects



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.