Command batching allows Replication Server to send multiple commands to the data server as a single command batch. You can put multiple commands in a language function-string output template, separating them with semicolons (;). If the database is configured to allow command batches, which is the default, Replication Server replaces the semicolons with that connection’s DSI command separator character before sending the function string in a single batch to the data server. The separator character is defined in the dsi_cmd_separator option of the alter connection command.If the connection to the database is not configured to allow batches, Replication Server sends the commands in the function string to the data server one at a time. To enable or disable batching for a database, use the alter connection command.
To use command batching, enter:
batch = on
batch_begin = on or off
The use of on for batch_begin reduces the number of network transfers.
use_batch_markers = off
Additional batch markers are not required.
When set batch is “on,” you must also specify the following configuration:
dsi_cmd_seperator set = ;
If you do not specify this configuration, ECDA ignores the commits after each batch , and all the replicate requests are rolled back after the dsi connection fades out.
For information on setting batch and dsi_cmd_separator options by using the alter connection command, see the Replication Server Reference Manual.
