Articles & Content
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
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.