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).
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be