RE: lock table overflow

Posted in 2000

Henry Benoit — Wed, 31 May 2000 11:50:57 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, Try to increase (ie : double the value) the parameter LOCKS in the onconfig file. If you do a big processing, you may try to lock at page level for this table, or even lock the entire table before processing. Ben > -----Original Message----- > From: Ameerul@mesiniaga.com.my [SMTP:Ameerul@mesiniaga.com.my] > Sent: Wednesday, May 31, 2000 4:58 AM > To: informix-list@iiug.org > Subject: lock table overflow > > HI guys/ladies, > > I'm using IDS 7.24 UC5-1 on AIX 4.2.1. Does anyone know why this error > occurs. I got it in my log > file. > > "lock table overflow - user id 230 session 1329" > > How can i overcome it? > > Thank you. > > regards > Ameerul