Articles & Content


DB2 UDB Indexes - An insiders look (C11)

Topic: DB2 for z/OS

Subtopic: 2005

DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: John Lyle (IBM Silicon Valley Lab)

This presentation will introduce DB2 UDB indexes. After a brief description of the different index types, this presentation will detail the indexing enhancements that are available with DB2 UDB V8. This includes varying length indexes, indexes with long keys, data-partitioned secondary indexes, table controlled partitioning, etc. Will cover catalog indexes and how they change during migrations and the V8 ENFM process.

EXP. LEVEL: Intermediate


An introduction to DB2 UDB indexes

Indexes with long keys

Indexes with varying length keys

Index partitioning

Index altering and Index summary

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.