Changing Replication Server parameters

You can modify configuration parameters that affect the current Replication Server by using the configure replication server command at the Replication Server.

To change default configuration parameters using configure replication server, log in to Replication Server and execute configure replication server at the isql prompt. The syntax is:

configure replication server
		set config_param to 'value'

where config_param is a character string that corresponds to the configuration parameter name and value is a character string representing the setting you want for the parameter. The config_param string must match an entire parameter name. You must restart Replication Server for the new parameters to take effect.

Example 1

For example, to change the maximum number of messages allowed in the Open Server message queue to 5, log in to the source Replication Server and:

  1. Execute the configure replication server command:

    configure replication server set num_msgs to '5'
    
  2. Restart the Replication Server.

    Refer to “Starting Replication Server” for information about starting Replication Server.

Example 2

This example uses configure Replication Server to change the ha_failover parameter to enable Failover support for all non-RSSD connections from a Replication Server to Adaptive Servers.

  1. Execute configure replication server. Log in to the Replication Server for which you want to enable Failover support and enter:

    configure replication server
    set ha_failover to 'on'
    

    See “Configuring the replication system to support Sybase Failover” in Chapter 7, “Replication System Recovery,” in the Replication Server Administration Guide Volume 2.

  2. Restart the Replication Server.

    Refer to “Starting Replication Server” for information about starting Replication Server.

Configuration changes take effect after you restart Replication Server.

Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for more information about using configure replication server.

Parameters affecting security are covered in Chapter 8, “Managing Replication Server Security” Parameters affecting performance are discussed in Chapter 4, “Performance Tuning” in the Replication Server Administration Guide Volume 2.