Logging Modes
The OnLine engine provides for three modes of logging operation. The selection of logging mode is important to the issue of data recovery in the event of a system crash.
Until the contents of the logical log buffer are flushed to disk, the transaction log records that the buffer holds are at risk should the system go down. If the system crashes with data in the logical log buffers, any changes to the database held in the buffer will not be recoverable. The three logging modes represent increasing degrees of data survivability.
No Logging
If the database is created with no logging, there is still a small amount of activity directed towards the logical logs and logical log buffers. Any statement that uses data definition language ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
