Hi,
DB2 9.7 fp 3a /Win 2008 R2

I have two tablespaces TBS1 and TBS2. TBS1 contain only tables and TBS2 contain only Indexes for the TBS1 tables.

I want to reorg one big table (around 40GB). If I do the offline TABLE reorg using TEMP, the HWM of the TBS2 will be effected ?

What is the best way to reorg this table without effecting any HWM?

Thanks.

As far as I know:

HWM can go up (or down) during offline table reorg if TEMP is not used. When TEMP is used, TBS1's HWM should not be affected. When indexes are rebuilt, db2 will use TEMP (if needed). So, TBS2's HWM should not be affected during index rebuild.

If the tablespace was created in 9.7, HWM can be lowered, so it is not a big issue. If created before 9.7, even if db is upgraded to 9.7, then you may have to worry about HWM.

Thanks for your comments.
Marcus, I migrated the db from v8.2. So the TBS was not created in v9.7.
I am thinking to create new TBS and move all the tables/indexes. But its a big job as we have very limited maintenance time.

The perticular table in a REGULAR TBS but the INDEXES are in LARGE TBS.
When I reorg using TEMP, the TEMP TBS should be LARGE or REGULAR or it doesnt matter?

Thanks

I believe LARGE is only for permanent data and DMS.