Re: Error -121 (cannot write log record) on update in Informix SE 5.01 in a Transaction

TA TUAN wrote > >Informix SE 5.01 seems to have a problem with some kind of >transaction. >As reading a table, we update each rows of the same table, one row at >a time. If we commit after each update, no problem. In the case of a >global transaction (commit after the last updated row), we got the >error 346 followed by Isam error 121. The number of rows updated is >about 300 and enough space is available for Informix Logs. > >If you are award about known problems, thanks to you to help us. Are you using Unix. Which operating system, vendor? On most (elderly) Unix, the lock table has a fixed size. As long as your transaction is open, every modified record needs one entry. You could increase the number of locks, but there will still be a hardcoded limit. Or better, change your application logic. -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................