suspend distributor

Suspends the Distributor thread for a connection to a primary database.

Syntax

suspend distributor data_server.database

Parameters

data_server – The data server name. If the database is part of a warm standby application, data_server is the logical data server name.
database – The database name. If the database is part of a warm standby application, database is the logical database name.

Examples

Example 1 – Suspends the Distributor thread for the pubs2 database in the LDS data server:
```
suspend distributor LDS.pubs2
```

Usage

Use suspend distributor to suspend a Distributor thread for a logical or physical connection to a primary database.
To resume the Distributor thread, use resume distributor.
The distributor thread reads incoming primary database transactions and forwards them to subscribers. Turn off the distributor to enhance performance in a warm-standby-only environment that has only a standby database and no subscribers.

Permissions

suspend distributor requires “sa” permission.

Related reference

resume distributor

Created December 12, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com