Upgrade Guide for DB2 UDB for z/OS and OS/390 > Database and UI Upgrade Planning >
About Database Clustered Indexes
Upgrades: Release 6.x only. Environments: All environments. If you created clustered indexes on base tables, and the upgrade introduces a different clustered index on the same table, the upgrade process re-creates custom indexes as nonclustered and creates the Siebel index as clustered. For IBM DB2, indexes that reside on tables with append mode enabled are re-created as nonclustered indexes during the upgrade. (Tables created with append mode enabled do not support clustered indexes.)
|