Show TOC

drop routeLocate this document in the navigation structure

Closes the route to another Replication Server.

drop route to <dest_replication_server>
 [with primary at <dataserver.database>] 
 [with nowait]

The name of the Replication Server whose route is to be dropped.

with primary

Specifies the connection from the primary database that you want to drop a dedicated route from.

with nowait

Instructs Replication Server to close the route, even if it cannot communicate with the destination Replication Server. Use with nowait only as a last resort. This clause forces Replication Server to drop a route that has subscriptions or is used by an indirect route. Additional steps are usually required to remove the invalid references from the RSSDs of the affected Replication Servers.

Example 1

Drops the route from the site where the command is entered to the SYDNEY_RS Replication Server:

drop route to SYDNEY_RS
Example 2

To drop the dedicated route between the RS_NY primary Replication Server and the RS_LON replicate Replication Server for the NY_DS.pdb1 primary connection, at RS_NY enter:

drop route to RS_LON
 with primary at NY_DS.pdb1
  • drop route closes the route from the Replication Server where it is entered to the specified Replication Server.

  • You must drop the dedicated route before you drop a shared route.

    After you drop a dedicated route, transactions from the specified primary connection to the destination Replication Server go though the shared route.

    See Replication Server Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication > Dedicated Routes.

  • Before dropping a route, you must:
    • At the destination Replication Server, drop all subscriptions for primary data in databases managed by the source Replication Server.

    • Drop any indirect routes that use the route.

    For example, in this figure, route I-1 is an indirect route from the primary Replication Server (PRS) to the replicate Replication Server (RRS) via the intermediate Replication Server (IRS). It uses direct routes D-1 and D-2.

    Figure 3-4 shows 3 replication servers namely P R S, I R S, and R R S.  P R S has a direct route to I R S called D-1 and I R S has a direct route to R R S called D-2. There is also an  indirect route called I-1 from P R S to R R S with I R S acting as the intermediate replication server.
    Figure 1: Example of Direct and Indirect Routes

    Before you can drop direct route D-2, you must drop all subscriptions at the replicate Replication Server for replication definitions at the primary or intermediate Replication Server, then drop indirect route I-1.


    Use the with nowait clause only as a last resort. Use the with nowait clause only if you do not intend to ever use the destination Replication Server, or if you must drop the route from the source Replication Server while the destination Replication Server is unavailable, or if you are attempting to add or change login names and passwords for direct routes. Avoid using the with nowait clause whenever possible so that the destination Replication Server can be updated correctly.

    The clause forces Replication Server to drop a route even if the route contains transactions in the outbound queue of the route. As a result, Replication Server may discard some transactions from the primary connections. The clause instructs Replication Server to drop the dedicated route even if the route cannot communicate with the destination Replication Server.

    After you use the with nowait clause, use the sysadmin purge_route_at_replicate command to remove all references to a primary Replication Server such as subscriptions and route information, from the system tables at the replicate Replication Server.

  • After dropping a route using with nowait, you can use sysadmin purge_route_at_replicate at the (former) destination site to remove subscriptions and route information from the system tables at the destination.

  • If the Replication Server from which the route is to be dropped is an intermediate site for another Replication Server, the route cannot be dropped. See the Replication Server Administration Guide Volume 1 for more information.

  • For Replication Servers with ERSSD, if the route being dropped is the last route originating from this source, then:
    • ERSSD Replication Agent is shut down

    • Log transfer is turned off from the ERSSD at the end of dropping the route


drop route requires “sa” permission.