RE: Lots of locks

Posted in 2000

JOHN CARLSON — Tue, 11 Jul 2000 10:06:53 -0400 — source: Informix-list mailing list archive (1991-1998)

Depends on the severity of the problem. If the app needs to finish NOW, then up the LOCKS and debug later. If I remember correctly, each lock only uses 44 bytes or so. The only way that you could determine the number of LOCKS required would be to isolate the SQL that uses all these locks and see what it's trying to accomplish. > -----Original Message----- > From: gorgos@my-deja.com [SMTP:gorgos@my-deja.com] > Sent: Tuesday, July 11, 2000 6:36 AM > To: informix-list@iiug.org > Subject: Lots of locks > > I've got a customer that has an application that keeps running out of > locks. We've upped the LOCKS in onconfig, but I'm reluctant to keep > doing this due to extra requirement of shared mem. Is there a way of > finding out how many locks the application requested, or is it just a > matter of adding LOCKS until the application is successful ? > > Thanks > > > Sent via Deja.com http://www.deja.com/ > Before you buy.