Cleaning Up the Destination Replication Server

Manually clean up the destination server's side of the route after running drop route with the with nowait option.

1. Verify that all the messages from the source Replication Server are gone from the Data Server Interface (DSI) queues.
2. From the rs_subscriptions system table, delete all the system table subscriptions entered by this site when the route was created.
3. Delete rows from the rs_rules system table for these subscriptions.
4. Clean up user subscription entries from the rs_subscriptions and rs_rules system tables.
5. 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.

6. Delete the entry for this route from the rs_routes system table.
7. Delete the entry for the source Replication Server from the rs_locater system table.