Altering High Water mark for DMS tablespace

Nageswaran · #1 (**permalink**) 02-10-06, 14:31

Hello all

I am working on DB2 UDB Verion 8.2.1. I have added more space to the tablespace. Now i have to reduce the size. But it's not allowing me to reduce the size below highwater mark.
Is there any way to reduce the size of the container?
Is there any way to change the highwater mark without any outage.

Thanks
Nageswaran

n_i · #2 (**permalink**) 02-10-06, 14:38

db2dart /LHWM will suggest the ways of lowering the high watermark.

Nageswaran · #3 (**permalink**) 02-10-06, 14:49

Whether we have to take the database down....thanks

sathyaram_s · #4 (**permalink**) 02-12-06, 19:30

IIRC, yes ...

Having a look at the documentation will definitely help

Cheers
Sathyaram

Quote:

Originally Posted by Nageswaran

Whether we have to take the database down....thanks

Cougar8000 · #5 (**permalink**) 04-03-08, 10:04

I know I am bringing dead to life, but I figured it might help someone. I just spent a good amount of time on this so others don't have to.

We have DMS tbs where HWM is seriously out of reality with current data. Db2dart in this case was suggesting >>>> => EXPORT all data from table, drop the table, disconnect, reconnect, recreate the table, and LOAD the data back into the table.<<< as the only option. I know there are times where it tells you to reorg/deactivate and then possibly rebuild indexes. This was not the case.

Touching data should be the last thing on anyone’s mind. I have dropped and rebuild indexes and HWM were right were it should be.

In the cases where it told to do a reorg first, I have found no benefit of doing reorg what so ever. The only feasible and useful option is to rebuild indexes regardless what db2dart says.

SuperKuper · #6 (**permalink**) 04-03-08, 15:46

Rebuilding indices may help if they are in the same tablespace as data, which often is not the case. The official response from IBM on this subject: "We are aware of the problem. There is no documented way to affect HWM. We are working on a solution."

Cougar8000 · #7 (**permalink**) 04-04-08, 11:07

Quote:

Originally Posted by SuperKuper

Rebuilding indices may help if they are in the same tablespace as data, which often is not the case. The official response from IBM on this subject: "We are aware of the problem. There is no documented way to affect HWM. We are working on a solution."

Great to see you here Gene.

Thanks for the responce.

Cougar8000 · #8 (**permalink**) 10-14-08, 16:06

Well, it seams that dropping table and indexes does not lower HWM either. Gene, have you heard anything from IBM on this? Anyone else were able to lower HWM? I really do no feel like dropping and rebuilding 77 tables.

Thank you.