RE: lock table overflow
An excerpt from my onconfig:
LOCKS 250000 # Maximum number of locks
BUFFERS 60000 # Maximum number of shared buffers
Note that BUFFERS and LOCKS depend on how much RAM you can dedicate to
Informix. I have 2GB, so 60,000 buffers isn't a whole lot, really.
Unless you are scrambling for RAM, I'd bump your locks to at least
50,000 and buffers to at least 2,000-3,000. The book says add buffers
to account for 1/4 of your physical memory... that would be excessive
for most applications.
-EEM
-----Original Message-----
From: Bill Hamilton [mailto:bham@finsco.com]
Sent: Wednesday, August 20, 2003 2:05 PM
To: malcolm.iiug; informix-list iiug
Subject: Re: lock table overflow
After bringing the server online for about 2 hours, onstat -p shows"
ovrlocks = 12
ovrbufs = 23
bufwaits = 265372
lokreqs = 64million+
In onconfig:
LOCKS = 20,000BUFFS = 200
Does this seem reasonable?
If not, what values would be appropriate?
What other parameters should I check?
> Bill,
> what is onstat -p showing for ovlocks?
>
sending to informix-list
sending to informix-list