RE: Lock table overflow ?

Posted in 1999

Yarlagadda, Ravi — Tue, 26 Oct 1999 16:21:54 -0400 — source: Informix-list mailing list archive (1991-1998)

You need to increase onconfig parameter LOCKS. If it is high volume of records, better to use other load utilities like dbload. with regards, Ravi Yarlagadda -----Original Message----- From: M@iiug.org [mailto:M@iiug.org] Sent: Tuesday, October 26, 1999 12:45 PM To: informix-list@iiug.org Subject: Lock table overflow ? Entry from my online.log every evening its exactly the same when I'm selecting * data from one table and inserting into another for safe keeping and clearign down for the next days transactions What is this - and how can I solve it ? 19:50:06 Lock table overflow - user id 0, session id 1997 19:50:06 Process exited with return code 1: /bin/sh /bin/sh -c/usr/informix/log_full.sh 3 21 "OnLine resource overflow: 'Locks'." "Lock table overflow - user id 0 System = Sun Enterprise 3000 - Informix 7.2 - Solaris 2.7 -