Commands to Manage Dedicated Routes

Use create route, drop route, resume route, and suspend route to manage and monitor dedicated routes.

Include the with primary at dataserver.database clause in the command to specify a dedicated route, where dataserver.database is the primary connection name.

See create route, drop route, suspend route, and resume route in Replication Server Reference Manual > Replication Server Commands.

Command Syntax Command and Parameter Changes
create route
create route to dest_replication_server {
 with primary at dataserver.database |
 set next site [to] thru_replication_server |
 [set username [to] user]
 [set password [to] passwd]
 [set route_param to 'value' 
      [set route_param to 'value']... ]
 [set security_param to 'value' 
      [set security_param to 'value']... ]}

If you specify a user ID when you create a dedicated route, the user ID must be a valid user.

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

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 through the shared route.

Warning!  Use the with nowait clause only as a last resort.

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.

If you use the clause, use sysadmin purge_route_at_replicate at the former destination site to remove subscriptions and route information from the system tables at the destination.

See Replication Server Administration Guide Volume 1 > Manage Routes > Drop Routes > drop route comand.

suspend route
suspend route to dest_replication_server
 [with primary at dataserver.database] 
 
resume route
resume route to dest_replication_server
 [with primary at dataserver.database] 
 [skip transaction with large message]