You can also use parameters to determine when to start and stop transaction grouping and compilation.
dsi_compile_max_cmds – specifies, in number of commands, the maximum size of a group of transactions. When RTL reaches the maximum group size for the current group that it is compiling, RTL starts a new group.
If there is no more data to read, and even if the group does not reach the maximum number of commands, RTL completes grouping the current set of transactions into the current group. The default is 10,000 commands.
dsi_command_convert – specifies how to convert a replicate command. A combination of these operations specifies the type of conversion:
Combinations of operations for dsi_command_convert include i2none, u2none, d2none, i2di, t2none, and u2di. The operation before conversion precedes the “2” and the operations after conversion are after the “2”. For example:
d2none – do not replicate the delete command. With this option, you do not need to customize the rs_delete function string if you do not want to replicate delete operations.
i2di,u2di – convert both insert and update to delete followed by insert, which is equivalent to an autocorrection. If you disable row count validation by setting dsi_row_count _validation off, Sybase recommends that you set dsi_command_convert to i2di,u2di to avoid duplicate key errors and allow autosynschronization of databases during replication.
t2none – do not replicate the truncate table command.
The default for dsi_command_convert is none, which means there is no command conversion.
alter connection to IQSRVR.iqdb set dsi_compile_max_cmds to ‘50000’ go
alter connection to IQSRVR.iqdb set dsi_bulk_threshold to ‘15’ go
alter connection to IQSRVR.iqdb set dsi_command_convert to ‘i2di,u2di’ go
alter connection to IQSRVR.iqdb set dsi_compile_retry_threshold to '200' go
See Replication Server Reference Manual > Replication Server Commands > alter connection for full descriptions of the parameters.