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

In article <4oje35$hp5@news.sct.fr>, TA TUAN <tatuan@worldnet.fr> writes >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. 5.01 has a bug which causes it to create one lock (in the UNIX lock table) for each row updated evan if you 'LOCK TABLE EXCLUSIVE' first. If you aren't out of room in the file system containing the tx log, I think you are out of UNIX locks - 'sar -v' in SVR4. Default is 400 so this is quite possible. i) LOCK TABLE EXCLUSIVE ii) Upgrade SE to 5.02 or later (bug fixed!) iii) Increase size of UNIX lock table -- Sally Woolrich