Configuring RTL

Replace the examples that show how to set the configuration parameters with alter connection in “Sybase IQ replicate database configuration issues” in Chapter 11, “Sybase IQ Replicate Data Server Issues.”

For example, after you enable RTL, you can set different values for the parameters:

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

Note: You must execute a separate alter connection command for each parameter you want to change. Do not enter more than one parameter after entering alter connection.