1) 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.
For SMS, this is not applicable
2)Reorg is option to change the high water mark. db2dart can also be used.
Amit Rai.
-----Original Message-----
From: divakar
[mailto:db2udbdba-ezmlmshield-x40018883.[Email address protected]
Sent: Saturday, May 28, 2005 10:23 AM
To: LazyDBA Discussion
Subject: High Water Mark
I found this term when I did "list tablespaces show detail".
What is High Water Mark. What does it mean when it is equal to the
number of Used Pages in the TableSpace. How can we change its value.
Divakar
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page