How to reduce the highwatermark for a DMS tablespace?
This is a discussion on How to reduce the highwatermark for a DMS tablespace? within the DB2 forums, part of the Database Server Software category; --> How to reduce the highwatermark for a DMS tablespace in V8.2? I have tried doing classic reorg on the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-07-2008, 11:15 AM
| |||
| |||
 Re: How to reduce the highwatermark for a DMS tablespace? 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      |
|
05-07-2008, 11:15 AM
| |||
| |||
| Re: How to reduce the highwatermark for a DMS tablespace? 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? |
|
05-07-2008, 11:15 AM
| |||
| |||
| Re: How to reduce the highwatermark for a DMS tablespace? 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 |
|
06-30-2008, 07:37 AM
| ||||
| ||||
| Re: How to reduce the highwatermark for a DMS tablespace? On May 5, 1:48*pm, "The Boss" <use...@No.Spam.Please.invalid> wrote: > 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 Thanks Lennart,Jeroen and AJ |
Linear Mode
