Configuring HVAR

Replace the examples that show how to set the configuration parameters with alter connection in “High Volume Adaptive Replication to Adaptive Server” in Chapter 4, “Performance Tuning.”

For example, after you enable HVAR, 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.