commit_time_inc

Default: –1 (This parameter is commented out.)
Range: 0 – 300 seconds
Related parameters: commit_absn_inc, commit_update_inc, commit_txn_inc

The commit_time_inc parameter allows the DATABridge Client to override the DBEngine CHECKPOINT CLIENT EVERY n SECONDS parameter setting by causing DBEngine to generate a commit at the next quiet point after n seconds have elapsed in the current transaction. This parameter determines one of many conditions under which DBEngine should generate a commit.

When this value is not specified, as in the case of the default setting, DATABridge Client uses an internal value of –1. This value indicates that it won't attempt to override the settings for the corresponding DBEngine parameter (whose default value is 0). The value -1 is not a valid setting, per se, and will result in a "value out of range" error.

A value of 0 disables the use of this parameter by DBEngine. A value that exceeds the value specified in the DBEngine control file is ignored.

If commit_absn_inc, commit_update_inc, commit_time_inc, and commit_txn_inc are specified, DBEngine commits at the next quiet point after the conditions are satisfied.