We are experiencing Package Cache Overflow in production DB. On average every two weeks the is an overflow occurs. First occurence follows buy anothe abour 5 hours lates. Second is followed by third one about an hour later an then few minutes . . . . in about 10 hours total there are many overflows. applications hang and needs a restart.
IBM support informed that there is an issue with current fixpack,but will be fixed in next,due mid December. They also advised to do FLUSH PACKAGE CACHE every time the situation arises, also schedule on regular basis. This did not solve the problem, because last time first overflow occured 3 hours after a FLUSH.
Now only way is that I monitor package cache use regularly. May be every hour.
Can someone advise me which function or view will provide me such info. That is, currently used package cache and available package cache, so that I may be able to tell when there is an alarming situation.
I guess (not sure) following lines show it.
Node number = 0
Memory Pool Type = Package Cache Heap
Current size (bytes) = 116391936
High water mark (bytes) = 153747456
Configured size (bytes) = 17178820608