Changing parameters affecting all connections

To set default configuration parameters for all connections originating at the source Replication Server, use the configure replication server command. Refer to Table 7-1 for a list of configuration parameters that affect connections that you can set with configure replication server.

The syntax for configure replication server is:

configure replication server
 set database_param to 'value'

Example 1

Here is an example of using configure replication server to change the dsi_fadeout_time parameter so that the DSI connection does not close. Log in to the source Replication Server and enter:

  1. Suspend all connections from the source Replication Server. For each connection, enter:

    suspend connection to data_server.database
    
  2. Execute configure replication server. Enter:

    configure replication server
    set dsi_fadeout_time to '-1'
    
  3. Resume suspended connections from the source Replication Server. For each connection, enter:

    resume connection to data_server.database
    

Configuration changes take effect after you resume the connections.

Example 2

Here is an example of using 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.

Configuration changes take effect after you resume the connections.