Transaction logging

Posted in 1997

Richard Thomas — 23 Jul 1997 13:08:17 -0400 — source: Informix-list mailing list archive (1991-1998)

OK, here's a quick one. A quick look at the Databases option from the main menu of tbmonitor shows that neither of the databases on our system uses logging (I didn't set the system up!!). BUT, we have had problems with the logical logs filling up due to a long transaction (message file entries like 'Aborting Long Transaction'), and the logical logs grow during normal OLTP operation, when no changes are being made to the structure of the databases. If transaction logging is currently off, how come the logical logs are so 'active'. If I've completely misunderstood something, please be gentle ;-) TIA, Richard. Richard Thomas -------- The Music Store -------- Brentford, UK OnLine 5.03.UC2 / SCO Openserver 5.0.2 / Twin P133 with SCO SMP 3rd party mail order application (4GL). In house reports (SQL/ACE/sh.) Plan: learn 4GL, Java and Omnis (now what shall I do next week?)