Closes the route to another Replication Server.
drop route to dest_replication_server [with nowait]
The name of the Replication Server whose route is to be dropped.
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.
Drops the route from the site where the command is entered to the SYDNEY_RS Replication Server:
drop route to SYDNEY_RS
drop route closes the route from the Replication Server where it is entered to the specified Replication Server.
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 Figure 3-4, 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: 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 if you will never use the destination Replication Server again or if you must drop the route from the source Replication Server while the destination Replication Server is unavailable. Avoid the with nowait clause whenever possible so that the destination Replication Server can be updated correctly.
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.
alter route, create connection, create route, sysadmin purge_route_at_replicate
