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.

Use the following syntax 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:

configure replication server
		set config_param to 'value'

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” on page 297 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.

Configuring dynamic parameters

Several Replication Server configuration parameters are changed to dynamic, allowing you to change their values using the configure replication server command. You no longer need to restart the Replication Server for the new values to take effect.Table 4-3 lists the dynamic configuration parameters.

Table 4-3: Dynamic configuration parameters

init_sqm_write_delay

init_sqm_write_max_delay

memory_limit

num_concurrent_subs

queue_dump_buffer_size

sqm_recover_segs

sqm_warning_thr_ind

sqm_warning_thr1

sqm_warning_thr2

sqt_max_cache_size

sqt_init_read_delay

sqt_max_read_delay

sts_cachesize

sts_full_cache_system_table_name

Use the new admin config command to retrieve the values of these parameters.

The admin config syntax is:

admin config [,”connection” |,“logical_connection” |,“route” ] [,server
[,database]] [,configuration_name]

See the Replication Server Reference Manual, for a detailed information in using this new command.