SEO

How to reduce the highwatermark for a DMS tablespace in V8.2? I have
tried doing classic reorg on the table in the tablespace twice, but
the highwatermark is lowered. Any ideas?

On May 5, 12:44 am, rajdb2 <vrajendrare...@gmail.com> wrote:
> How to reduce the highwatermark for a DMS tablespace in V8.2? I have
> tried doing classic reorg on the table in the tablespace twice, but
> the highwatermark is lowered. Any ideas?

See db2dart command at:

http://publib.boulder.ibm.com/infoce...74%65%72%22%20

You probably want to do something like:

db2dart <yourdb> /LHWM /TSI <tblspc id> /np <size>

/Lennart

Keep in mind that, in v8, db2dart should only be run against a
deactivated database.

aj

rajdb2 wrote:
> How to reduce the highwatermark for a DMS tablespace in V8.2? I have
> tried doing classic reorg on the table in the tablespace twice, but
> the highwatermark is lowered. Any ideas?

rajdb2 wrote:
> How to reduce the highwatermark for a DMS tablespace in V8.2? I have
> tried doing classic reorg on the table in the tablespace twice, but
> the highwatermark is lowered. Any ideas?

Lennart already showed you a pointer to the IBM docs.
In addition to that, I would like to refer you to this very nice article on
the subject from Gernot Ruban:
http://www.ruban.de/DB2_luw/HWM_redu...reduction.html

HTH

--
Jeroen