Re: Update failed question

Tammy Croteau (tammy@scooter) wrote: : I am using Infomix SE v5. I am going through a series of : updates embedded within a BEGIN/COMMIT transaction. About : half way through I am getting an error (Informix -346, : CISAM -121) which seems to indicate that 1) either the : disk is full or 2) the transaction log is having problems. : I have plenty of space on my hard disk and the transaction : log is quite small, additionally no other users are in the : database so records are not locked and neither the index or : the database is corrupt. I can update the same : number of records if each update is treated as one transaction : or if I update the entire table through ISQL. : : works : for (i=0; i<600; i++) { : $BEGIN : $UPDATE .... : $COMMIT : } : fails : $BEGIN : for (i=0; i<600; i++) { : $UPDATE .... : } : $COMMIT : Any suggestions or solutions? My guess would be that you have <600 locks configured in your UNIX kernel. But I would have hoped you would get more meaningful error messages if I'm right. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.