No it is not.
The formula can be used as: (1 -Inserts/Lookups) * 100
In your case, you get 28.57%. You aim is to get => 80%
Be careful. If the cache is empty, you'll obviously get a low ratio.
You should snapshot when the db has been activated, users have logged on
and have started using their application.
Normally a low ratio is an indication of a Package Cache too small.
HTH, Pierre
xixi wrote:
the formula for package cache hit ratio is
1 - (package cache inserts/package cache lookups), what the result
would be a effective ratio? currently we have cache inserts=25, cache
lookups=35, so i get ratio =0.28, is this a good number?
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.