SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:56 PM
| ||||
| ||||
 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 Instance  B2 Node:000PID: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 B2 Node:000PID: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 B2 Node:000PID: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      |
|
02-26-2008, 05:56 PM
| ||||
| ||||
| Re: package cache overflow "xixi" <dai_xi@yahoo.com> wrote in message news:c0f33a17.0405051340.46e92535@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. |
Linear Mode
