DB2 UDB v7.2

When migration of v7.2 database to v8, the indexes still exist as a type 1 index in v8.

We can convert the indexes to type 2 by a REORG of Index with CONVERT option. However, the question is whether dropping all indexes on the table and recreating them would create type 2 indexes or type 1 indexes?

Ofcourse, if type 1 indexes already exist in V8 then any new index will be a type 1 index again.

TIA.

From the manual:

"All indexes created by DB2 prior to Version 8 are type-1 indexes. All indexes created by Version 8 are Type 2 indexes, except when you create an index on a table that already has a type 1 index. In this case the new index will also be of type 1."

My interpretation is that if you drop all the indexes on a table, and then recreate them, they will be type-2. However, if you have a primary key, you must drop it in order to drop the unique index.

Dropping all the indexes and then recreating will accomplish the task. But I will recommend CONVERT, I have used it many times for conversion and you dont' have to worry about primary key or data corruption.