onmode -c: Force a checkpoint

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onmode-- -c--+--------------------+-------------------------><
                |        .- 15 ----. |   
                +-block--+---------+-+   
                |        '-timeout-' |   
                '-unblock------------'   

Element Purpose Key considerations
-c Forces a checkpoint that flushes the buffers to disk. 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. While the database server is blocked, users can access it in read-only mode. Use this option to perform an external backup on HCL Informix®.

For more information, see the IBM® Informix Backup and Restore Guide.

timeout Specifies the number of seconds to wait for checkpoints to clear before returning to the command prompt. The timeout option applies only if the DELAY_APPLY configuration parameter is configured (see DELAY_APPLY Configuration Parameter. If the DELAY_APPLY configuration parameter is enabled, the checkpoint requested by the primary server might not arrive at the secondary server for an extended period of time. It is also possible that no other checkpoints are staged in the staging directory. The default timeout value is 15 seconds and the maximum timeout allowed is 10 minutes (600 seconds). See 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 HCL Informix.

For more information, see the IBM Informix Backup and Restore Guide.

This command has an equivalent SQL administration API function.


Copyright© 2019 HCL Technologies Limited