Altering or Dropping Alternate Replicate Connections

Alter or drop default or alternate replicate connections using the alter connection and drop connection commands.

The data server and database names that you specify in the commands can be the default or alternate replicate connection names.

You can use configuration parameters available to alter connection when you configure an alternate or default replicate connection.

For example, to set dsi_max_xacts_in_group to 40 for the TOKYO_DS.rdb_conn2 alternate replicate connection, enter:

alter connection to TOKYO_DS.rdb_conn2
set dsi_max_xacts_in_group to '40'
go