Joined: 19 Feb 2006
|Posted: Wed Jul 09, 2008 4:12 pm Post subject: reduce tablespace - reclaim space - reset high water mark.
|Reorg all tables in the tablespace you wish to reduce.
A) List tablespaces show detail to get tablespaceid to reset.
B) db2dart <dbname> /LHWM /TSI <tbspaceid> /np 0
run the dart command with '/np 0' to find out how low it can be set.
C) get the min pages from the end ot the dart report.
D) run the command again to set the highwater mark.
db2dart <dbname> /LHWM /TSI <tbspaceid> /np <minpages+10%>
The high watermark should be lowered now.