optimize_col_updates

Default: False
Range: True or False

The optimize_col_updates parameter specifies whether the define or redefine command should set the DSOPT_Optimize_4_CDC bit (value 1) in the ds_options field of the DATASETS table. This bit indicates that client will optimize column updates to eliminate changes to columns whose values are unchanged. To do this, stored procedures are abandoned in favor of pure SQL without the use of host variable. This usually slows the update speed of the Client, but the overall process ultimately takes less time because SQL Server or Oracle replication sends signficantly less data to the remote database.

Caution: Using this parameter will significantly slow update processing by the Client. If you are replicating your relational database, enabling this feature may provide some benefit if replication is very slow.

See also the enable_optimized_col parameter, which allows the user to disable this option without running a redefine command.