Re: Lock table overflow ?

M I would lock at a table level. That way you grab only one lock for each table. HTH Sujit M@iiug.org on 10/26/99 09:44:40 AM Please respond to M@iiug.org To: informix-list@iiug.org cc: (bcc: Sujit Pal) 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 -

>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 - > Lock Table Overflow problem you should increase more number of Max # of Locks under onmonitor in parameter -> share memery page and re start engine Suphote.S.