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.