commit_update_inc

Default: -1 (This parameter is commented out.)
Range: 0 – 200,000
Related parameters: commit_absn_inc, commit_time_inc, commit_txn_inc

The commit_update_inc parameter allows the DATABridge Client to override the DBEngine CHECKPOINT CLIENT EVERY nnn UPDATE RECORDS parameter setting. It does this by causing DBEngine to generate a commit at the next quiet point after the nnn updates have been sent to the DATABridge Client. 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 1000). 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 one or more of these conditions are satisfied.