DB2 Version 8 Major Indexing Enhancements  Product documentation

Abstract
Mike Shadduck, IBM® Silicon Valley Lab

This presentation describes the index changes in DB2® for z/OS®, Version 8.


Content
Mike Shadduck, IBM Silicon Valley Lab
Learn about the most significant index changes since the introduction of the Type 2 Index. See what has been done to enhance such things as improved index only access, true varying length keys, availability of an index during schema changes, long keys, and data partitioned secondary indexes (DPSIs).

This presentation includes information on the following topics:

1. Index problems addressed in Version 8 2. True varying length index keys 3. Schema changes and how they relate directly to the index 4. Long index keys 5. What is a DPSI?

http://www-1.ibm.com/support/docview.wss?rs=64&context=SSEPEK&q1=major+indexing+enhancements&uid=swg27004020&loc=en_US&cs=utf-8&lang=en

P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software GroupTechnical Sales DB2