Enabling Multithreaded RepAgent and Multiple Paths for RepAgent

Enable multithreaded RepAgent and configure it to use additional paths from the primary database.

By default, the Adaptive Server RepAgent consists of a single thread that scans the primary database log, generates LTL, and sends the LTL to Replication Server. With multithreaded RepAgent, the scanning and sending activities are performed by separate threads.

If you use multithreaded RepAgent, there is always a default path to send data to the Replication Server. RepAgent creates the default path when you initially enable RepAgent on a database.

Multiple replication paths can process only transactions that are generated by Adaptive Server 15.7 and later.

  1. Set the Memory Available to RepAgent
    You must provide sufficient memory for the RepAgent thread in Adaptive Server before you enable and configure multiple RepAgent sender threads.
  2. Enable Multithreaded RepAgent
    Enable or disable a multithreaded RepAgent which uses separate threads for the RepAgent scanner and sender activities.
  3. Set the Number of Send Buffers
    Set the maximum number of send buffers that the scanner and sender tasks of multithreaded RepAgent can use.
  4. Set 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.
  5. Enable Multiple Scanners for RepAgent
    Enable a RepAgent scanner thread for each available replication path from the primary database.
  6. Set the Maximum Scanner Schema Cache Size
    To optimize Adaptive Server RepAgent memory consumption and improve replication performance, set the maximum amount of mermory that each scanner thread can use to store object schema required for replication.
  7. Set the Frequency of Secondary Truncation Point Requests
    Set the frequency of truncation point request intervals for RepAgent.
  8. Monitor RepAgent and Display Configuration Parameter Settings
    Use Adaptive Server stored procedures to display the settings of the RepAgent configuration parameters and other information on RepAgent multithreaded and multiple path status.