RE: lock table overflow
No.
Something in your application requires more locks. You need to determine
what that is and how many locks it requires, then double or triple that
number. Locks do not use much memory.
200 Buffers - you are trying to run Informix in 400Kb (if 2Kb page, dont
recall your OS). How much memory, or spare memory, do you have on your
server? How big is your database? Buffers may be between 20000 and 400000
depending upon the available memory in your server - or may be even larger.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Bill Hamilton
> Sent: Thursday, 21 August 2003 7:05 a.m.
> 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,000> BUFFS = 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