467,923 Members | 1,845 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

High water mark

Hi:
how to reduce the tablespace's High water mark?
ths!
Aug 17 '07 #1
  • viewed: 3868
Share:
4 Replies
On Aug 17, 4:26 am, <nint...@126.comwrote:
Hi:
how to reduce the tablespace's High water mark?
ths!
The high water mark indicates how "full" the tablespace was. I.e The
maximum number of pages that were used. The only way to reduce it
would be to remove data from your database, which you probably don't
want to do.

Aug 17 '07 #2
On Aug 17, 5:49 pm, Otto Carl Marte <Otto.Ma...@gmail.comwrote:
On Aug 17, 4:26 am, <nint...@126.comwrote:
Hi:
how to reduce the tablespace's High water mark?
ths!

The high water mark indicates how "full" the tablespace was. I.e The
maximum number of pages that were used. The only way to reduce it
would be to remove data from your database, which you probably don't
want to do.
Correction, removing data won't decrease the high-water mark, it will
just give you more free pages. Why do you want to reduce the
tablespaces high-water mark?

Aug 17 '07 #3
On Aug 16, 7:26 pm, <nint...@126.comwrote:
Hi:
how to reduce the tablespace's High water mark?
ths!
http://www-1.ibm.com/support/docview...id=swg21006526

Aug 17 '07 #4

"jefftyzzer" <je********@sbcglobal.net>
??????:11*********************@m37g2000prh.googleg roups.com...
On Aug 16, 7:26 pm, <nint...@126.comwrote:
>Hi:
how to reduce the tablespace's High water mark?
ths!

http://www-1.ibm.com/support/docview...id=swg21006526
thank you very much! i see.
Aug 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Vincento Harris | last post: by
1 post views Thread by Erik Hendrix | last post: by
1 post views Thread by Asphalt Blazer | last post: by
reply views Thread by Ntsakane | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.