After a transaction is prepared or terminated in a database with unbuffered logging
A number of log records cause flushing of the logical-log buffers in a database that uses unbuffered logging.
The log records that cause flushing are:
- COMMIT
- PREPARE
- XPREPARE
- ENDTRANS
For a comparison of buffered versus unbuffered logging, see the SET LOG statement in the IBM® Informix® Guide to SQL: Syntax.