Re: Logical Log

Every row inserted uses a lock. Up your number of available locks or try changing the lock mode of the table to page for the load or lock the table in exclusive mode. It is not complaining about logs. >From: musher@btl.net >Reply-To: <musher@btl.net> >To: <informix-list@iiug.org> >Subject: Logical Log >Date: Sat, 20 Feb 1999 11:00:37 -0600 > >Dear User, > >I have been trying to get a large file loaded on a database with = >transaction logging and the loading keep bombing out. I am getting an = >error in the log 'Lock Table Overflow.', Eventhough, i have 5 logs it = >bombs at the exact time that the current log gets to 100% used. Why = >does it not use the other logs that are empty and why when I do an = >ontape -a it only free up the current log. If i repeat the command then =>it backs up the other logs one at a time. > >marie=20 > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com