package cache overflow

[xixi]

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

[Mark 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.

[Mark 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.