All -

Aix 6 with DB2 UDB 9.1.4

I've got thousands of indexes in a single tablespace (this is a
purchased app...I didn't do this...).

I need to CONVERT TO LARGE on my tablespace...I will reorg all indexes
now.

My question: Is there a way to know by querying the catalog (or some
other means) if my indexes ALL support the larger RID? I don't wanna
miss any...

Thanks,

-B

Try the following:

db2 "select tabschema, tabname, tabtype, index_type, large_rids, large_slots
from sysibmadm.admintabinfo"


--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Jan 27, 4:35*pm, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:
Thank You! That's just what I wanted.