Execute the Adaptive Server stored procedure rs_helproute 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.
Refer to the Replication Server Troubleshooting Guide for information about correcting route creation problems.
