RE: Lock Table Overflow - onconfig

>From: William Rice <ricew@operamail.com> >To: informix-list <informix-list@iiug.org>, Thiel Franky ><franky.thiel@INFOHOS.BE> >Subject: RE: Lock Table Overflow - onconfig >Date: Thu, 23 Sep 1999 13:09:54 -0400 > >The number of locks is configured by the >LOCKS parameter.> >do note, this might be an application issue as well. There >are times when an application should be taking a table level lock >but is not, hence using an inordinate number of locks. > >Will > Yeap, if your database is with logging and you modify a lot of rows ( or loading it from an external file, or deleting ), you should put a lock on the table, otherwise theres going to be a lock for each row you update/insert/delete. > > >===== Original Message From Thiel Franky <franky.thiel@INFOHOS.BE> ===== > >We get an error in the Informix log-file. Lock table overflow. > >What do we have to change in the onconfig-file ? > > > >Kind Regards, > > > >Franky Thiel > >franky.thiel@Infohos.be > >------------------------------------------------------------ >This e-mail has been sent to you courtesy of OperaMail, a >free web-based service from Opera Software, makers of >the award-winning Web Browser - http://www.operasoftware.com >------------------------------------------------------------ > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com