To clean up the destination Replication Server:
Verify that all the messages from the source Replication Server are gone from the DSI queues.
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.
Clean up user subscription entries from the rs_subscriptions and rs_rules system tables.
Execute this command against each system table:
delete from system_table
where prsid = sourceRS_siteid
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 Reference Manual.
Delete the entry for this route from the rs_routes system table.
Delete the entry for the source Replication Server from the rs_locater system table.
