Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Tammy Croteau — — source: Informix-list mailing list archive (1991-1998)
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 |
============================================================
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.