drop route Command

Use the drop route command to drop routes.

You can also drop routes from Sybase Central. The syntax for the drop route command is:

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

Include the with primary at dataserver.database clause in the command to specify a dedicated route, where dataserver.database is the primary connection name. 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 > Performanc Tuning > Multi-Path Replication > Dedicated Routes.

The with nowait option instructs Replication Server to close the route even if it is unable to communicate with the destination Replication Server.

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.

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.