View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 05:56 PM
xixi
 
Posts: n/a
Default package cache overflow

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 InstanceB2 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 InstanceB2 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 InstanceB2 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
Reply With Quote