Dear group, We are investigating the performance of our DB2 server. One of the issues to look at are the buffer pools. It is not difficult to determine the current buffer pool hit ratio with a snapshot. Currently these hit ratios are very good (> 99,0 %).
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? 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? Best regards. Raoul Joemman Martinair ***************************************************************** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Martinair Holland N.V., its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ***************************************************************** - ::: 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
