Output from rs_helproute at the source Replication Server

The output is the same as the drop route command, except that the route status reads:

Route is being dropped with nowait. ...

instead of:

Route is being dropped. ...

1. Verify that all the messages from the source Replication Server are gone from the DSI queues.

2. From the rs_subscriptions system table, delete all the system table subscriptions entered by this site when the route was created. Delete rows from the rs_rules system table for these subscriptions.

3. Clean up user subscription entries from the rs_subscriptions and rs_rules system tables

4. Execute this command against each system table:

   delete from system_table
       where prsid = sourceRS_siteid
   

   where:

   • system_table is the name of the system table (rs_subscriptions or rs_rules).

   • sourceRS_siteid is the site ID of the source Replication Server.

   For more information about the delete command, see the Adaptive Server Enterprise Reference Manual: Commands.

5. Delete the entry for this route from the rs_routes system table.

6. Delete the entry for the source Replication Server from the rs_locater system table.