If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > reduce/remove containers in DMS

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-24-04, 13:32
udbdb2 udbdb2 is offline
Registered User
 
Join Date: Nov 2003
Posts: 121
reduce/remove containers in DMS

Hi:
How to change and force high water mark to move so we can drop a container from DMS Tablespace ? we have only 20% used TSpace with multiple containers so need to drop some for other use but high water mark is set to 80% plus level of total space ...

Any help ? ,thanks in advance!!

Happy holiday and merry christmas to all!!!
Reply With Quote
  #2 (permalink)  
Old 12-24-04, 16:51
quigleyd quigleyd is offline
Registered User
 
Join Date: Nov 2002
Location: Delaware
Posts: 186
run a reorg on the tables in the tablespace. It frees up some of the space.

To see what is holding the space,

db2dart <DBname> /tsi <tablespace id>

The second option is /LHWM. This will make suggestions about ways to lower the high-water mark for a given tablespace. The tablespace ID must be provided along with a desired high-water mark. The /TSI and /NP options can be used to specify these values, otherwise they will be prompted .
__________________
David Quigley
Reply With Quote
  #3 (permalink)  
Old 12-25-04, 06:48
Tank Tank is offline
Registered User
 
Join Date: Feb 2004
Location: Copenhagen
Posts: 220
Arrow

Reorganizing doesn't lower the watermark

The high watermark is set by the
highest page ever used!! - and
you cannot remove containers without
lowering it.

If you have free space, you can move
tables to another TS, drop it, create it again,
and move them back - otherwise ud DART

- but please be careful !!

BOW
__________________
Kristian K. Hansen
Project Supervisor
National Board of Health
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On