To change the next intermediate site for an existing indirect route, perform the following steps.
Enter the following command at the source Replication Server, from which the direct route originates:
suspend route to dest_replication_server
At each Replication Server that manages a database with a RepAgent, enter:
suspend log transfer from all
and follow the instructions in “Quiescing a replication system”. This procedure quiesces the replication system so that messages will be redirected to your new routing configuration without error.
Create any additional routes that the indirect route will use. See “Creating routes” for details.
If the current Replication Server does not already have a direct route to the Replication Server that you will specify as the new intermediate site for the indirect route, create the route.
If the Replication Server that you will specify as the new intermediate site for the indirect route does not already have a direct or indirect route to the destination site, create the route.
For the indirect route for which you are specifying a new intermediate Replication Server, enter the following command at the source Replication Server where dest_replication_server is the destination Replication Server for the route you are altering, and thru_replication_server is the new intermediate Replication Server for the route:
alter route to dest_replication_server set next site thru_replication_server
Resume log transfer connections by entering the following command at each Replication Server where you previously suspended log transfer:
resume log transfer from all
Resume the suspended route by entering the following command at the source Replication Server:
resume route to dest_replication_server
