Re: Logical Log
--Boundary_(ID_3tw/FUECZXALjx4ZkHW5Jg)
Content-type: text/plain; charset=us-ascii
Content-disposition: inline
Content-transfer-encoding: 7BIT
Marie
Your error message is "Lock Table Overflow" which means you are running out
of locks. Since you have transaction logging turned on, try locking the
table in exclusive mode in your load session and unlock it after. This will
take only 1 lock. I think you may have lock mode set to row for your table,
so it takes a lock for each row in the table. An alternative approach is to
set the lock mode to page. It will decrease the number of locks required.
HTH
Sujit
musher@btl.net on 02/20/99 09:00:37 AM
Please respond to musher@btl.net
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: Logical Log
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
--Boundary_(ID_3tw/FUECZXALjx4ZkHW5Jg)
Content-type: text/html; name=att-1.htm
Content-description: Internet HTML
Content-disposition: attachment; filename=att-1.htm
Content-transfer-encoding: 7BIT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>Dear User,</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>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.</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>marie </FONT></DIV></BODY></HTML>
--Boundary_(ID_3tw/FUECZXALjx4ZkHW5Jg)--