You can suspend either a specific (primary or replicate) database connection, or all primary or all replicate database connections.
When you suspend a replicate database connection, ASE Replicator suspends
all of the subscriptions in that connection.
To suspend a specific primary database connection
Use sp_suspendprimaryconn with the following syntax to specify a database connection:
sp_suspendprimaryconn "conn_name"
where conn_name is the connection name in the form ds.db.
To suspend all primary database
connections
Use sp_suspendprimaryconn without specifying a database connection:
sp_suspendprimaryconn
To suspend a specific replicate database connection
Use sp_suspendreplicateconn with the following syntax to specify a database connection:
sp_suspendreplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
To suspend all replicate
database connections
Use sp_suspendreplicateconn without specifying a database connection:
sp_suspendreplicateconn
After a database connection is suspended, you must resume
the connection to continue replication.
