On May 5, 12:44 am, rajdb2 <vrajendrare...@[EMAIL PROTECTED] > 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
