Force a Checkpoint

Force a  Checkpoint:
 
|-- -c--+---------+---------------------------------------------|
        +-fuzzy---+
        +-block---+
        '-unblock-'

Element	Purpose	Key Considerations
-c	Forces a checkpoint that flushes the buffers to disk	Additional Information: You can use the -c option to force a sync checkpoint if the most recent checkpoint record in the logical log was preventing the logical-log file from being freed (status U-B-L).
block	Blocks the database server from any transactions	Additional Information: While the database server is blocked, users can access it in read-only mode. Use this option to perform an external backup on Dynamic Server. References: For more information, see the IBM Informix Backup and Restore Guide.
unblock	Unblocks the database server	When the database server is unblocked, data transactions and normal database server operations can resume. Use this option after you complete an external backup on Dynamic Server. References: For more information, see the IBM Informix Backup and Restore Guide.
fuzzy	Performs a fuzzy checkpoint	Additional Information: Use the onmode -c fuzzy option to force a fuzzy checkpoint. Then use the onstat -b command to check the number of modified (dirty) buffers. The modified buffers that are still in the buffer cache contain fuzzy transactions. References: For more information, see the chapter on checkpoints and fast recovery in the IBM Informix Administrator's Guide.