Designating Buffered Logging

The following example creates a database that uses a buffered log:

CREATE DATABASE vehicles WITH BUFFERED LOG 

If you use a buffered log, you marginally enhance the performance of logging at the risk of not being able to re-create the last few transactions after a failure. (See the discussion of buffered logging in the IBM Informix Database Design and Implementation Guide.)