Use rs_helproute Stored Procedure

Use rs_helproute to obtain comprehensive route status information, including the current state of routes you are creating.

Execute the rs_helproute stored procedure in the RSSD at the source or destination Replication Server for the route. The syntax for the rs_helproute stored procedure is:

rs_helproute [replication_server]

If you specify the name of a Replication Server, rs_helproute returns information only for routes for which the named Replication Server is a source or destination. Otherwise, it returns information for all routes for which the current Replication Server is a source or destination.

rs_helproute returns two types of information:

Route status, which reflects the state of the route at the site where rs_helproute is executed. A route is valid when rs_helproute at both source and destination returns “Active.”
Other route status values are:
- Being created
- Being dropped
- Being dropped with nowait
List of system table subscriptions, which tells you the system table subscriptions that are being created. If a route is being dropped, it tells you which subscriptions are being dropped.

If no system table subscriptions are listed, the route has been created and is in working order.

See Replication Server Reference Manual > RSSD Stored Procedures > rs_helproute.

Refer to the Replication Server Troubleshooting Guide for information about correcting route creation problems.