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.)