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 -

M wrote: > > 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 - Increase the LOCK parameter in the ONCONFIG file so there are at least on lock for each row in that table and one for each index times each row and bounce the engine, OR execute "LOCK TABLE insert_table IN EXCLUSIVE MODE;" before running the INSERT INTO .... SELECT .... statement so that you only need one lock, OR use my dbcopy.ec utility which can do the copy about 3 times faster and will commit every N rows (like dbload) so that you do not use as many locks. Dbcopy.ec is part of the package utils2_ak in the IIUG Software Repository. Art S. Kagel

Try increasing more locks for your instance. Its difficult to give you hand ... you should post more information about the version of your server and what platform its running and ... what your configuration is .. just so that others (who wish to help) can properly identify why this error is occuring on you. Lloyd Aj Wilson. M wrote in message <940956373.22841.0.nnrp-11.c1ed9731@news.demon.co.uk>... >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 - > >

Hi, The problem occurs because the number of rows that you want to insert causes the system to hold more locks than has been configured. Lock the table that you are inserting into in exclusive mode using : LOCK TABLE <tabname> IN EXCLUSIVE MODE and then INSERT into the table. cheers > 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 - > > Sent via Deja.com http://www.deja.com/ Before you buy.