RE: Lock table overflow

I've got the same problem. In my case the lock table overflow was preceded with 12 dynamic allocations of 100,000 locks. We start with 300,000. So we are growing to 1,500,000. And it only takes 30 seconds. Obviously we need more locks but I am reluctant to add that many as our other similar sites have a lot less. The application is sales ledger period end and in december worked fine with 300,000 locks but why the sudden increase? Any ideas? Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of LUQUE Valdivia Omar Sent: 18 January 2005 14:02 To: informix-list@iiug.org Subject: Lock table overflow Hi everyone, I have observed that problem: 02:04:14 Lock table overflow - user id 1, session id 9425 02:04:14Lock table overflow - user id 1, session id 9425 02:04:14 Lock table overflow - user id 1, session id 9425 What Happend? Please, Help me Thanks Omar. sending to informix-list sending to informix-list

Since we have no idea of your application and what it's doing, how can we say anything very useful? Have you investigated which thread is taking the extra locks? (I'm assuming it's some version of IDS that's running) And have you investigated the logic of the program to see what is happening this month (period end) that is different to last month? At least you are not using SE on HP/UX which simply lets the whole set of Informix processes freeze rather than risk allocating more memory to the Unix lock table.