But what we want to know now is if the size of the pool is ok. Maybe the pool is to large and only a small piece is in use, this is a waste of memory. How can we detect how much space is claimed within the buffer pool?
Generally the bufferpool will be 100% utilized -- this is a function of how DB2 cleans pages out of the bufferpool (i.e. a modified LRU algorithm).
For example if we have a buffer pool of 10.000 pages and the pool is currently using 3.000 pages. How do we detect the number of pages used for this buffer pool?
It is difficult to determine whether all pages in the bufferpool have been used.
The best way to tune a bufferpool is to make a change and observe what happens as a result of the change. So, you could try decreasing your bufferpool to 9,000 pages, and keep an eye on the hit ratio. You need to monitor this on an ongoing basis to determine if your changes have a positive, negative or no impact on performance.
Good luck,
--
ian d bjorhovde -> [EMAIL PROTECTED]
internet mobile audio -> http://mobileaudio.com- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
