I recommended to Pham, Anh to try db2dart to find what needs to be done
to reduce the hwm. But I was thinking about ranges and how they might
have a hand in keeping a mark somewhat artificially high. Does anyone
know if this could be and if so can you drop a range or the containers
that make up the range to help reduce the hwm?
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x81657602.[Email address protected]
Sent: Thursday, March 30, 2006 1:05 PM
To: LazyDBA Discussion
Subject: RE: the HIGH WATER MARK value
How do you know that you have lots of empty space? Whats your free
space set to?
and remember that it takes a minimum of 5 extents to start with.
"Schleicher
Jeremy D. "
<db2udbdba-ezmlms
To
hield-x29449487.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com>
cc
03/30/2006 12:56
Subject
PM RE: the HIGH WATER MARK value
Explain this to me then. I have a very high watermark but lots of empty
wasted space but can't reduce the size of the tablespace because of the
watermark. How can I reduce the size of the tablespace?
Jeremy Schleicher
ERP Database Administrator
Florida State University
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x65117914.[Email address protected]
Sent: Thursday, March 30, 2006 12:54 PM
To: LazyDBA Discussion
Subject: RE: the HIGH WATER MARK value
The high-water mark is the page number of the highest allocated page in
the table space. For example, a table space has 1000 pages and an extent
size of 10, resulting in 100 extents. If the 42nd extent is the highest
allocated extent in the table space that means that the high-water mark
is
42 * 10 = 420 pages. This is not the same as used pages because some of
the extents below the high-water mark may have been freed up such that
they are available for reuse.
This means that you have data in that tablespace, or free space up to
that high water mark to the end of the extent.
"Pham Anh "
<db2udbdba-ezmlms
hield-x67200436.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
03/30/2006 12:44
PM
Subject
RE: the HIGH WATER MARK value
...This the PROD and the task reorg is done I would not be able to do
INPLACE as it is slower than normal reorg
My wonder is except, may be a unload, reload or INPLACE reorg, the
db2dart would do an analyze..., I would not want to see it in backup
mode or whatever could be affected to users
Would any other way I would try ?
How is the UDB deal with that ? is it a bug here?
the HWM is staying there until when ?? and this is just statistic, how
it could prevent us to reduce the unused space,
I become nasty to see that way of UDB I guess! oh what a design !
Thanks all
-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x83071587.[Email address protected]
Sent: March 30, 2006 12:04 PM
To: LazyDBA Discussion
Subject: RE: the HIGH WATER MARK value
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
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