Show TOC

suspend distributorLocate this document in the navigation structure

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.