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

package cache overflow

P: n/a
we are using db2 udb v8.1 on win64bit 2003 server, i found this in
db2diag.log, our application used jdbc for connection to this remote
server, why the overflow number keep increasing, what should i do with
this? our maxappls=60, pckcachesz = 859

2004-05-05-14.53.11.720000 Instance:DB2 Node:000
PID:2232(db2syscs.exe) TID:464 Appid:AC1004ED.G890.00FC56AF3D38
access plan manager sqlra_cache_mem_please Probe:21 Database:NJIPD

Package Cache Number Overflows
0x000006FBF99AD41C : 0x0000006A j...

2004-05-05-14.53.11.990000 Instance:DB2 Node:000
PID:2232(db2syscs.exe) TID:464 Appid:AC1004ED.G890.00FC56AF3D38
access plan manager sqlra_cache_mem_please Probe:60 Database:NJIPD

Package Cache Overflow
2004-05-05-14.53.12.280000 Instance:DB2 Node:000
PID:2232(db2syscs.exe) TID:2916 Appid:AC100419.G7FC.00FC567CAD46
access plan manager sqlra_cache_mem_please Probe:70 Database:NJIPD

Package Cache Overflow #106 Resolved.
memory needed: 8064
current used size (OSS): 3411323
maximum cache size (APM): 3412910
maximum used size (OSS): 6193152
owned size (OSS): 5750784
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
we are using db2 udb v8.1 on win64bit 2003 server, i found this in
db2diag.log, our application used jdbc for connection to this remote
server, why the overflow number keep increasing, what should i do with
this? our maxappls=60, pckcachesz = 859

Increase the pckcachesz size. See the DB2 Administration Guide: Performance
about this parameter. In your case, I would increase by at least a factor of
5 and check the db2dialog.log to see if it keeps on overflowing. If you have
sufficient real memory to throw at this parameter, you probably don't want
any significant overflow.
Nov 12 '05 #2

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
we are using db2 udb v8.1 on win64bit 2003 server, i found this in
db2diag.log, our application used jdbc for connection to this remote
server, why the overflow number keep increasing, what should i do with
this? our maxappls=60, pckcachesz = 859

Increase the pckcachesz size. See the DB2 Administration Guide: Performance
about this parameter. In your case, I would increase by at least a factor of
5 and check the db2dialog.log to see if it keeps on overflowing. If you have
sufficient real memory to throw at this parameter, you probably don't want
any significant overflow.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.