Hello,
I just migrated the db2 8.2 to 9.7. FP3a
One of my tablespace which contains ONLY INDEXES. It is a 4K page regular TBS. But it used nearly 16 million pages. (almost full).

Now, I have converted to LARGE. Then added more pages to the containers.
Then did the INDEX REORG. The REORG was successfull, but it put the HWM over 22million pages (before 15million pages).

As this TBS was created using v8.2 I can not reduce the HWM, without recreating the TBS.

So, I restored the database again with and converted to large again.
This time I did the TABLE REORG and all the INDEXES were rebuilt (according to the diag.log) during the TABLE REORG. But the HWM did not changed. still same value (15million pages).

Can some one give me some advise on this please.
Can I leave this as it is? or do I need to do anything else?
How can I check that this indexes will use the 6bit RID?

Please remember, this TBS contain only INDEXES (No tables).

Please advise.
Thanks.

alter tablespace has this option
ALTER TABLESPACE - IBM DB2 9.7 for Linux, UNIX, and Windows

Check large_rids and large_slots here:
IBM DB2 9.7 for Linux, UNIX and Windows Information Center