Could your help me, I so need this inf and I am searching ...

.. also I have went throught the archived emails to see if the topic is there, yes, it was, but could not find a
'firm' solution

I got a reply by John to "truncate" option on reorg, but I am doing the reorg normal, not INPLACE

my rerog is

REORG TABLE xxxxx INDEX xxxxx allow no access
Thanks all

-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x2405649.[Email address protected]
Sent: March 30, 2006 10:57 AM
To: LazyDBA Discussion
Subject: the HIGH WATER MARK value


Good morning all,

I ran a reorg and no option USE, e.g it will reorg with temspace using the same Tablespace

and here is the after result,

Tablespace ID = 7
Name = S1WAAI012
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 180000
Useable pages = 179968
Used pages = 81248
Free pages = 98720
High water mark (pages) = 154048 -----> increased during reorg
----------------

now when I want to reduce the size to 100 000, I got this

There is not enough space in the table space "S1WAAI012
" for the
specified action.

Explanation:

Space is being removed from a tablespace using one or more of
the DROP, REDUCE, and RESIZE container actions. However, the
amount of space being removed is greater than the amount of space
above the high-water mark.

----------------

How the High water mark (pages) would be updated to release that one-time statisctic and let we able to reduce space
at once when we want ---


Thanks for you reply

Anh


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page