Drop Routes

Dropping a route closes the route from the Replication Server where you execute the command to a specified remote Replication Server.

Dropping a route performs the following actions on participating Replication Servers:

Drops system table subscriptions.
If the route is direct, the outbound stable queue is dropped and the RSI thread is stopped.
Deletes information regarding the route.

You cannot drop the route if:

It is a direct route used by any indirect routes to additional destination Replication Servers.
The source Replication Server has replication definitions that are subscribed to by the destination Replication Server.
The source Replication Server is designated as the primary site of a function-string class or error class. The primary site of a derived function-string class is the same as its parent class.

You can monitor the status of the route while it is being dropped by one of:

In Sybase Central, view status information in the right pane of the Sybase Central main window.
From the command line, execute the rs_helproute stored procedure.

drop route Command
Use the drop route command to drop routes.
sysadmin purge_route_at_replicate Command
sysadmin purge_route_at_replicate removes all subscriptions and route information originating from a specified primary Replication Server after a route is dropped from that Replication Server.

Parent topic: Manage Routes