suspend connection command in sybase replication server

[Nagendra]

suspend connection
Description

Suspends a connection to a database.
Syntax

Code:

suspend connection
to data_server.database
[with nowait]

Parameters

data_server

The name of the data server with the database whose connection is to be suspended.

database

The name of the database whose connection is to be suspended.

with nowait

Suspends the connection immediately.

Examples
Example 1

Suspends the connection to the pubs2 database in the SYDNEY_DS data server.

suspend connection to SYDNEY_DS.pubs2

Usage

* Suspending a connection temporarily halts replication activities for the database.
* Connections are suspended so they can be altered with alter connection or so that maintenance can be performed. You can also use suspend connection to control when replicate databases are updated.
* While a connection is suspended, Replication Server holds transactions for the database in stable queues.
* If suspend connection is executed without the with nowait clause, Replication Server attempts to complete any transaction that is in progress. However, the connection to the data server may be suspended before the transaction is completed.
* To reactivate the connection, use resume connection.

Permissions

suspend connection requires “sa” permission.