"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

Norbert Munkel

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