Suspends the Distributor thread for a connection to a primary database.
suspend distributor data_server.database
The data server name. If the database is part of a warm standby application, data_server is the logical data server name.
The database name. If the database is part of a warm standby application, database is the logical database name.
Suspends the Distributor thread for the pubs2 database in the LDS data server:
suspend distributor LDS.pubs2
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.
suspend distributor requires “sa” permission.
