Altering database connections

To change the attributes of a database connection, use Sybase Central or perform the following steps at the Replication Server where the connection was created:

  1. Use suspend connection to suspend activity on the connection. See “Suspending database connections” for details.

  2. Execute the alter connection command. See “Setting and changing parameters affecting physical connections” for detailed instructions.

    NoteUsing the set log transfer off clause for the alter connection command drops the RepAgent connection from a primary site. Before using this clause, be sure there are no replication definitions defined for data in the database.

  3. Use resume connection to resume activity on the connection. See “Resuming database connections” for more information.

RSM

For instructions on changing the attributes of a connection in Sybase Central, see “Changing database connection properties” in the Replication Server plug-in help.

When you alter a connection in Sybase Central, you do not need to suspend or resume connections yourself; RSM Server performs these tasks for you.