467,171 Members | 1,263 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,171 developers. It's quick & easy.

Package cache hit ratio

Good day,

I've been monitoring a DB2 system and noticed a low package cache hit
ratio, I calculated it based on the formula in the db2 information center:

(1-(db.pkg_cache_inserts/db.pkg_cache_lookups))*100

as you can see below the average (most of the time) of the package cache
hit ratio is 30%

these are some values taken with a database snapshot:

Memory Pool Type = Package Cache Heap
Current size (bytes) = 15810560
High water mark (bytes) = 16728064
Configured size (bytes) = 8589934592 ---> Here i have
configured more than the water mark, and still have the 30%

and these are the package cache operations at the same point in time:

Package cache lookups = 22536477
Package cache inserts = 15406540
Package cache overflows = 0
Package cache high water mark (Bytes) = 14065030

What can i do to obtain a better cache hit ratio? :confused:

Thanks in advance.
Feb 28 '06 #1
  • viewed: 1708
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by lasmith3@pacbell.net | last post: by
9 posts views Thread by Matt | last post: by
4 posts views Thread by xixi | last post: by
10 posts views Thread by datapro01@yahoo.com | last post: by
1 post views Thread by Marek Wierzbicki | last post: by
1 post views Thread by Ramchandra | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.