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

Package Cache Overflow

P: n/a
i am using db2 udb v8.1 on win 64 bit, i found this on my db2diag.log

2003-11-12-13.20.05.550001 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:21 Database:NJIPD

Package Cache Number Overflows
0x000006FAFFBF141C : 0x00000001 ....

2003-11-12-13.20.05.780000 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:60 Database:NJIPD

Package Cache Overflow

2003-11-12-13.20.05.940000 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:70 Database:NJIPD

Package Cache Overflow #1 Resolved.
memory needed: 478
current used size (OSS): 3412054
maximum cache size (APM): 3412910
maximum used size (OSS): 5308416
owned size (OSS): 4866048

what does that mean? do i need to do anything? thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hello,
I faced the same problem some days ago. The PCKCACHESZ is set in
relation to MAXAPPLS but in DB2 V8 MAXAPPLS is set by default to
automatic. My experience is that this doesn't work. So just set the
MAXAPPLS to a fixed value e.g. 100 and then the error should not occur
again.
Another reason could be the connectivity you are using e.g. JDBC. In
case of JDBC the number of bound JDBC-packages could also be a reason
of the error.
But first try the MAXAPPLS.

Joerg

da****@yahoo.com (xixi) wrote in message news:<c0**************************@posting.google. com>...
i am using db2 udb v8.1 on win 64 bit, i found this on my db2diag.log

2003-11-12-13.20.05.550001 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:21 Database:NJIPD

Package Cache Number Overflows
0x000006FAFFBF141C : 0x00000001 ....

2003-11-12-13.20.05.780000 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:60 Database:NJIPD

Package Cache Overflow

2003-11-12-13.20.05.940000 Instance:DB2 Node:000
PID:1840(db2syscs.exe) TID:3068 Appid:AC100453.G761.00F8D15749BE
access plan manager sqlra_cache_mem_please Probe:70 Database:NJIPD

Package Cache Overflow #1 Resolved.
memory needed: 478
current used size (OSS): 3412054
maximum cache size (APM): 3412910
maximum used size (OSS): 5308416
owned size (OSS): 4866048

what does that mean? do i need to do anything? thanks

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.