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. > Implicit software Corporation I suspect that you are running out of locks.You can either increase the number of locks for your OS or issue the command lock table yourtable in exclusive mode This will save you the individual locks for every record updated. Regards Tolis -- +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+