Set the distribution model
for replication through multiple primary replication paths.
Prerequisites
Create the default and alternate connections from the primary Adaptive
Server to Replication Server, and enable multithreaded RepAgent. Enable multiple scanners
if you intend to set the distribution model to distibution by column filter.
Task
If you change the distribution model and you add new bindings or have existing
bindings that RepAgent cannot associate with the new distribution model , RepAgent displays
a warnimg that it will ignore some bindings under the new distribution model. However,
RepAgent retains the inactive bindings. If you revert to the distibution model that
corresponds with the type of the inactive bindings, RepAgent once again uses the formerly
inactive bindings. For example, if you change to distribution by column filter from
distribution by object binding, RepAgent ignores all the table and stored procedure
bindings that you have set.
- Set the distribution model:
sp_config_rep_agent database, ‘multipath distribution model’, {‘object' | 'connection' | 'filter'}
where:
- multipath distribution model is the distribution model
parameter for sp_config_rep_agent
- object – sets the model to distribution by object binding
which is the default
- connection – sets the model to distribution by connection
- filter – sets the model to distribution by filter
- Quiesce Replication Server and restart RepAgent.
See Replication Server Administration Guide Volume 1 > Manage a
Replication System > Quiesce Replication Server > Quiescing a Replication
System.