Chapter 3: Administering ASE Replicator

Suspending database connections

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.