Set the distribution mode for
replication through multiple primary replication paths from a primary Adaptive Server
database.
Prerequisites
Create the default and alternate connections from the primary Adaptive Server to
Replication Server, and enable multithreaded RepAgent.
Task
If you change to distribution by connection from distribution by object binding,
RepAgent ignores all the object bindings and displays a warning. RepAgent retains the
bindings if you revert to distribute by object binding and restart RepAgent.
- Set the distribution mode:
sp_config_rep_agent database, ‘multipath distribution
model’, {‘connection' | 'object’}
where:
- multipath distribution model – is the distribution mode
parameter for sp_config_rep_agent
- connection – sets the mode to distribution by connection
- object – sets the mode to distribution by object binding
which is the default
- Quiesce Replication Server and restart RepAgent.
See Replication Server Administration Guide Volume 1 > Manage a
Replication System > Quiesce Replication Server > Quiescing a Replication
System.