Set and Change Parameters Affecting Physical Connections

You set configuration parameters for a connection when you create it. Later, you can update those parameters with Sybase Central, the alter connection command.

You can change the configuration of either a single database connection or of all database connections that originate from a single Replication Server. If you are adding many database connections to a Replication Server, you may want to change configuration parameters affecting all connections in order to fine-tune server performance.

To change configuration parameters for all connections originating at the current Replication Server, use the configure replication server command.

Configuration parameters that are set for individual connections with alter connection override parameters that are set with configure replication server. Thus, you can set default parameters with configure replication server and then customize settings for specific connections with alter connection.

• Change Parameters Affecting a Single Connection
  After a connection is created, you can change its configuration parameters with the alter connection command.
• Change Parameters Affecting All Connections
  Use the configure replication server command to set default configuration parameters for all connections originating at the source Replication Server.
• Configuration Parameters Affecting Physical Database Connections
  Use alter connection with the parameter to change the attributes of a single connection or configure replication server to change the attribute of the parameter for all connections to Replication Server.
• Change Replication Server Connection Parameters to Improve Performance
  You can use configuration parameters to improve replication performance.