Distribution by Connection

In a Multi-Path Replication environment, you can use different distribution modes to achieve parallel replication and improved replication performance by distributing the replication load from the primary database through the available primary replication paths originating from the database.

With Replication Server 15.7 and Adaptive Server 15.7, you can bind objects, such as tables and stored procedures, to specific replication paths to enable the replication of these objects in parallel. See Replication Server Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication > Multiple Primary Replication Paths > Binding Objects to a Replication Path.

With Replication Server 15.7.1 and Adaptive Server 15.7 ESD #1, you can distribute the replication load by connection. The default mode is distribution by object binding. The Adaptive Server RepAgent does not support more than one distribution mode at a time.

In distribution by connection, the Adaptive Server RepAgent assigns transactions originated by different client processes to the available replication paths. Over time, data distribution balances across all available paths. Performance improves and replication load distribution is more uniform if there are many RepAgent paths available and the number of client processes is large.

See Replication Server Administration Guide: Volume 2 > Performance Tuning > Multi-Path Replication > Paraallel Transaction Streams > Distrubution Modes for Multi-Path Replication > Distribution by Connection.

• Changes to Adaptive Server Monitoring Tables
  If you select to distribute the replication load by connection, use the fields in the monRepSenders Adaptive Server monitoring table to provide a statistical snapshot of data distibution, and analyze Adaptive Server performance.