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.
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:
Execute the configure replication server command:
configure replication server set num_msgs to '5'
Restart the Replication Server.
Refer to “Starting Replication Server” for information about starting Replication Server.
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.
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.
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.
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.
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.
