How to reduce the highwatermark for a DMS tablespace?
in [DB2]
|
From: rajdb2 on 4 May 2008 18:44 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?
From: Lennart on 5 May 2008 03:14 On May 5, 12:44 am, rajdb2 <vrajendrare...(a)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/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/core/r0003477.htm?resultof=%22%64%62%32%64%61%72%74%22%20%22%68%69%67%68%22%20%22%77%61%74%65%72%22%20 You probably want to do something like: db2dart <yourdb> /LHWM /TSI <tblspc id> /np <size> /Lennart
From: aj on 5 May 2008 09:51 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?
From: The Boss on 5 May 2008 13:48 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_reduction/hwm_reduction.html HTH -- Jeroen
|
Pages: 1 Prev: Alter Table causes SQL0901N ( SQLSTATE=58004 ) Next: How to add leading zeroes |