How to find which index is type1 and which is type2 in a v8 database that have been migrated from V7.
I know when you migrate from v7 to v8 the indexes will not be converted from type1 to type2.

You can use the INSPECT Command.

Cheers
Sathyaram

what tells an Index is Type 1 or Type2

Did you try the inspect command ?

The output very clearly will say, among other things, whether an index is type1 or type2 ?

Cheers
Sathyaram

Thank You.
It worked !!
But i think this process involves too much of effort.
(1****n Inspect
2.Format the output)
On mainframe you can query system catalogs to find out the index is Type1 or Type2.
Iam trying to figure out similar way on UDB too