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

Default value for pool hit ratio

P: 1
Hi,

In one of the scenario, the pool hit ratio is -98%. What is the thresold for buffer pool hit ratio. If -98% is unacceptable, how can improve the buffer pool hit ratio.

Thanks
Gokul.N
Sep 21 '07 #1
Share this Question
Share on Google+
1 Reply


P: 1
The first thing to try to understand is that Hit Ratios are irrelevant as performance metrics. They cannot be converted into application elapsed time components, or into CPU seconds.
You need to focus on the IO rate/second as a real measure of system/pool/application performance.

For DB2 z/OS, there have been two hit ratio formulas in use over the years.

Application Hit (getpages - read IOs)/getpages totally useless

System Hit (getpages - SumOfAllPagesRead)/getpages this is somewhat indicative of pool performance, but there can be miinimal changes in the % but still a significant change in the underlying IO rate/sec. I am the author of this formula about 20 years ago, and this is the formula used in the IBM manuals today.

You can look at my papers and presentations on
www.responsivesystems.com
for in depth explanations of buffer pool performance and tuning perspectives.

Joel
Oct 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.