Replication Server 15.0 allows you to batch commands for non-ASE database servers. By batching commands, you may be able to achieve improved performance in Replication Server.
Support for command batching to non-ASE servers is achieved through the use of two function strings, rs_batch_start and rs_batch_end. These function strings store the SQL translation needed for marking the beginning and end of command batches. Use of these function strings is not necessary for Adaptive Server Enterprise or any other data server where the function strings rs_begin and rs_commit already support the needed functionality.
A DSI connection parameter, use_batch_markers, is used to control the processing of the two function strings, rs_batch_start and rs_batch_end. You can set use_batch_markers with alter connection and configure connection commands. If use_batch_markers is set to on the function strings rs_batch_start and rs_batch_end are executed. The default is off.
DSI must be correctly configured for batching of commands to the replicate data server. There are three DSI configuration parameters to consider for each connection that will be batching commands:
batch
batch_begin
use_batch_markers
For more information about configuring DSI for non-ASE data servers, see Chapter 5, “Replication Server Issues,” in the Replication Server Heterogeneous Replication Guide.
