Re: lock table overflow

Posted in 2003

Topics: Server Administration, Transactions, Locking & Isolation

Bill Hamilton — Thu, 21 Aug 2003 09:57:47 -0500 — source: Usenet: comp.databases.informix

The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on it. I upped the buffers to 400 and the locks to 40000. The service reported: 08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8. 08:47:27 Onconfig parameter RA_THRESHOLD modified from 2 to 4. I don't know how far I should push it. > > Only 200 BUFFERS seems a bit too few . . .. how much physical memory > is on your server? > > Any way to see what process is hitting the ovrlock condition?? > sending to informix-list

↪ replying to Bill Hamilton

Jay Aymond — Thu, 21 Aug 2003 11:00:25 -0500 — source: Usenet: comp.databases.informix

Only 400 buffers ... that still seems very low ... I would start at 5,000 and go up from there. "Bill Hamilton" <bham@finsco.com> wrote in message news:bi2nid$63a$1@terabinaries.xmission.com... > > The customer's server has 1GB of ram. > Unfortuately, it also is the web server, so IIS is running on it. > > I upped the buffers to 400 and the locks to 40000. > The service reported: > 08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8. > 08:47:27 Onconfig parameter RA_THRESHOLD modified from 2 to 4.> > I don't know how far I should push it. > > > > Only 200 BUFFERS seems a bit too few . . .. how much physical memory > > is on your server? > > > > Any way to see what process is hitting the ovrlock condition?? > > > > sending to informix-list

Glossary

onconfig