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

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