Enabling Multiple Scanners for RepAgent

Enable a RepAgent scanner thread for each available replication path from the primary database.

1. To configure RepAgent for multiple scanners, at the primary Adaptive Server enter:

   sp_config_rep_agent dbname, 'multiple scanners', {true|false}  

   where:

   • dbname – is the Adaptive Server primary database.
   • true – enables multiple scanners with a separate scanner thread for each replication path
   • false – enables only one scanner thread that all paths must share

   The default is false.
   For example, if you have three replication paths including the default path, and you set multiple scanners to true, RepAgent creates one scanner thread for each of the three replication paths.
   If you do not enter true or false, RepAgent displays the current setting for multiple scanners.
2. Restart RepAgent for the change to take effect.

Use sp_help_rep_agent to monitor scanner status and activity such as the path associated with the scanner task and the number of records scanned.. See Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_help_rep_agent for examples.