467,907 Members | 1,122 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

"Package Cache Overflow" in db2diag.log?

aj
DB2 v8 FP5
Red Hat AS/EL 2.1

I found the following in my db2diag.log:

2004-09-07-10.01.37.747898 Instance:oltp Node:000
PID:14637(db2agent (NDRDB)) TID:8192 Appid:C0455584.K508.00E507141135
access plan manager sqlra_cache_mem_please Probe:21 Database:NDRDB

Package Cache Number Overflows
0x10105374 : 0x00000002 ....

2004-09-07-10.01.37.754008 Instance:oltp Node:000
PID:14637(db2agent (NDRDB)) TID:8192 Appid:C0455584.K508.00E507141135
access plan manager sqlra_cache_mem_please Probe:60 Database:NDRDB

Package Cache Overflow

2004-09-07-10.01.40.202689 Instance:oltp Node:000
PID:14637(db2agent (NDRDB)) TID:8192 Appid:C0455584.K508.00E507141135
access plan manager sqlra_cache_mem_please Probe:70 Database:NDRDB

Package Cache Overflow #2 Resolved.
memory needed: 14944
current used size (OSS): 8559076
maximum cache size (APM): 9535487
maximum used size (OSS): 15974400
owned size (OSS): 14745600

Any ideas whats going on? What config value should I change?

TIA

aj
Nov 12 '05 #1
  • viewed: 2319
Share:
1 Reply
Hi,

aj wrote:
DB2 v8 FP5
Red Hat AS/EL 2.1

I found the following in my db2diag.log:

2004-09-07-10.01.37.747898 Instance:oltp Node:000
PID:14637(db2agent (NDRDB)) TID:8192 Appid:C0455584.K508.00E507141135
access plan manager sqlra_cache_mem_please Probe:21 Database:NDRDB


Well, you seem to use SMP (INTRA_PARALLEL ON). I went sick fiddling with
Parameters until IBM-Support pointed me to APAR IY55389. This looks very
much like this and was fixed with Fixpack 6. If you cannot install FP6
soon, disabling INTRA_PARALLEL would be a (poor) workaround.

have fun,

Norbert

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by John | last post: by
4 posts views Thread by Spook | last post: by
14 posts views Thread by TTroy | last post: by
2 posts views Thread by Jason Huang | last post: by
3 posts views Thread by SheldonMopes | last post: by
17 posts views Thread by StevePBurgess | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.