Using alter connection and the set log transfer option

Shut down log transfer using alter connection with the set log transfer option. To shut down log transfer, turn the set log transfer option off. For example:

alter connection to TOKYO_DS.pubs2
   set log transfer off

When log transfer is off, Replication Server removes the DIST thread, and RepAgent can no longer log in to Replication Server.

When Replication Server no longer recognizes the primary database, you must reestablish this connection using rs_init or create connection before you can use alter connection to set log transfer on.

To set log transfer on, turn the set log transfer option on. For example:

alter connection to TOKYO_DS.pubs2
set log transfer on