rs_helproute

The rs_helproute stored procedure displays the current state of a route and the subscriptions it is currently processing. Routes go through various states while being created, altered, or dropped.

Execute rs_helproute on the RSSD at the source or the destination Replication Server:
rs_helproute [replication_server]
where replication_server 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, rs_helproute 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. 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.

See the Replication Server Reference Manual.