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.