drop route

Closes the route to another Replication Server.

Syntax

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

Parameters

dest_replication_server – 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.

Examples

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
 go
```

Usage

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.

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.

Warning! 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

Permissions

drop route requires “sa” permission.