Update failed question
Posted in 1995
Topics: Transactions, Locking & Isolation
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? Tammy ============================================================ Tamara J. Croteau | tcroteau@ftc.nrcs.usda.gov CDSI | tammy@ftc.nrcs.usda.gov 2625 Redwing Rd., Suite 350 | Ft. Collins, Colorado 80526 | ============================================================