How to reduce the highwatermark for a DMS tablespace?
Question posted by: rajdb2
(Guest)
on
June 27th, 2008 07:20 PM
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?
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
|
|
June 27th, 2008 07:20 PM
# 2
|
Re: How to reduce the highwatermark for a DMS tablespace?
On May 5, 12:44 am, rajdb2 <vrajendrare...@gmail.comwrote:
Quote:
Originally Posted by
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/infoc...%74%65%72%22%20
You probably want to do something like:
db2dart <yourdb/LHWM /TSI <tblspc id/np <size>
/Lennart
|
|
|
June 27th, 2008 07:20 PM
# 3
|
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:
Quote:
Originally Posted by
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?
|
|
|
|
June 27th, 2008 07:20 PM
# 4
|
Re: How to reduce the highwatermark for a DMS tablespace?
rajdb2 wrote:
Quote:
Originally Posted by
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_red..._reduction.html
HTH
--
Jeroen
|
|
|
June 29th, 2008 08:25 PM
# 5
|
Re: How to reduce the highwatermark for a DMS tablespace?
On May 5, 1:48*pm, "The Boss" <use...@No.Spam.Please.invalidwrote:
Quote:
Originally Posted by
rajdb2 wrote:
Quote:
Originally Posted by
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_red..._reduction.html
>
HTH
>
--
Jeroen
|
Thanks Lennart,Jeroen and AJ
Not the answer you were looking for? Post your question . . .
180,428 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).
|
|
|
Top Community Contributors
|
