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.

NoteWhen you alter a connection in Sybase Central, you need to suspend and resume the connection before the new value will take effect.