Show TOC

resume distributorLocate this document in the navigation structure

Resumes a suspended Distributor thread for a connection to a database.

Syntax
resume distributor <data_server>.<database> [skip transaction]
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.

skip transaction

Instructs Replication Server to resume execution with the second transaction in the connection’s queue. The first transaction is written to the database exceptions log.

Examples
Example 1

Resumes the Distributor thread for the logical data server LDS and the <pubs2> database:

resume distributor LDS.pubs2
Usage
  • Use resume distributor to resume a Distributor thread suspended using suspend distributor or suspended by Replication Server.

  • Use skip transaction to resume connection when distributor is down due to:
    • message in inbound queue is longer than 16,000 bytes and site version has not been upgraded to Replication Server 12.5 and later, or

    • downstream Replication Server cannot accept new feature commands, for example, <bigint>.

Permissions

resume distributor requires “sa” permission.