Routes go through various states while being created, altered, or dropped. Execute the rs_helproute stored procedure on the RSSD at the source or the destination Replication Server to see the current state of the route:
rs_helproute [replication_server]
replication_server rs_helproute
is an optional parameter indicating the name of a Replication Server. If you enter this parameter, information is given for routes to and from the specified Replication Server. Otherwise, information is provided for all routes to and from the current Replication Server. For each route, returns:
Route status
Status identifies the state of the route protocol. The status of a route is different at the source and destination Replication Servers. You analyze the route status at the source and destination Replication Servers to determine the problem.
A list of system table subscriptions that are currently being processed
Incomplete materialization or dematerialization of system table subscriptions is one of the most common problems.
Because creating, altering, and dropping routes includes processing system table subscriptions, the list that rs_helproute returns helps you determine which subscriptions prevent you from proceeding to the next step in the process.
If you are creating a route, the list includes the system table subscriptions that are being created. If you are dropping a route, the list includes the system table subscriptions that are being dropped.
If no system table subscriptions are listed for a route, there are no problems with the system table subscriptions.
