By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

High water mark

P: n/a
Hi:
how to reduce the tablespace's High water mark?
ths!
Aug 17 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a

"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.