Manage Routes

A route is a one-way message stream from a source Replication Server to a destination Replication Server.

From each source Replication Server, you create one route for each destination Replication Server, no matter how many databases are managed by the source or destination Replication Servers.

Routes carry:

Data modification commands and applied functions or applied stored procedures from primary databases managed at the source Replication Server to replicate databases managed at the destination Replication Server
System table modification commands from a source Replication Server RSSD to a destination Replication Server RSSD
Request functions or request stored procedures from replicate databases to primary databases (in this case, the source is the replicate Replication Server and the destination is the primary Replication Server).

When you create a route, the source Replication Server:

Creates an RSI outbound queue to hold messages for the destination site
Starts an RSI thread that logs in to the destination Replication Server and transfers transactions from the RSI outbound queue to the destination Replication Server

Routing Preparation
Before you create or modify routes, you must verify that the relevant components of your replication system are running, and you have designed your routes.
Routing Rules
After you have determined your routing scheme, you can set up the required routes based on the routing rules.
Routing Schemes
Replication Server supports direct, indirect, and dedicated routes.
Create Routes
Create routes at the source Replication Server.
Configuring a Replication Server to Manage Primary Tables
You can add a route from a Replication Server that was previously configured as a replicate-only Replication Server.
Suspend and Resume Routes
When you alter a direct route, change its topology, or perform some other maintenance to a remote site, you must suspend the route so that messages are no longer sent to the destination Replication Server. After maintenance is completed for the route, you can then reactivate the route to resume activity.
Change Routes
Use alter route, or Sybase Central to change the topology, user name, password, and certain configuration parameters of a direct route.
Drop Routes
Dropping a route closes the route from the Replication Server where you execute the command to a specified remote Replication Server.
Upgrade Routes
Upgrading the route allows the Replication Servers to exchange information about newer software features.
Monitor Routes
Routes may display different statuses at different times. Acquire an overview of the utilities you can use to monitor the status of routes.