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

"Package Cache Overflow" in db2diag.log?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.