Setting the Maximum Number of Replication Paths for RepAgent

Set the maximum number of paths that you allow RepAgent to use to replicate data out of the primary database. RepAgent generates one RepAgent sender thread for each RepAgent path.

At the primary Adaptive Server, enter:
sp_config_rep_agent dbname, 'max number replication paths', 'max number replication paths value'
where dbname is the Adaptive Server primary database.
For example, to set max number replication paths to 3 on the pdb1 database, enter:
sp_config_rep_agent pdb1, 'max number replication paths', '3'

If max number replication paths is greater than 1, RepAgent continues to use the default path for all replicated objects that you do not specifically bind to a path.

If max number replication paths is less than the number of paths with replication objects bound to the paths, RepAgent reports an error and terminates.

Parent topic: Enabling Multithreaded RepAgent and Multiple Paths for RepAgent
Previous topic: Set the Number of Send Buffers
Next topic: Enable Multiple Scanners for RepAgent