All,

I was using the db2 utility db2inspect to identify those indexes that had not yet been converted from type 1 to type 2. After formatting the results, the results listed certain Object ID's (tables) that are referenced back to it's indexes.

Does anyone know of a way to find out what the table name is based on an object id? I need to know the table name to re-launch the convert index script.

Example of output:

Table phase start (ID Signed: 4, Unsigned: 4; Tablespace ID: 0) :

Data phase start. Object: 4 Tablespace: 0
The index type is 2 for this table.
DAT Object Summary: Total Pages 7 - Used Pages 7 - Free Space 13 %
Data phase end.

Thx

Use the tablespaceid and tableid columns in the syscat.tables table to identify the table.

Cheers
Sathyaram