Setting the Number of Worker Threads

Set the number of worker threads available to the global task manager which can then assign the threads to process tasks scheduled by SAP Replication Server modules.

  1. Change the number of worker threads available to the global task manager.
    Enter:
    configure replication server
set worker_thread_num to ‘number_of_worker_thread’
go
    where number_of_worker_thread specifies the number of worker threads.
  2. Restart SAP Replication Server.
  3. (Optional) Use admin who to check the status of the worker threads.
    For the worker threads, you see for example:
     Spid  Name    State          Info 
----  ------  -------        --------------------------
  11  Worker  Active         DIST Delivery Provision 103
  12  Worker  Active         Parallel Apply 104 1
  13  Worker  Awaiting Task  
    where:
    • Spid 11 – is a task for parallel processing in DIST for connection 103
    • Spid 12 – is a task for the distributed application of transactions in the DSI thread for connection 104. The "1" after "104" is the thread number of the DSI Executor (DSI/E) thread. If you enable parallel DSI for a connection, you can see the thread numbers of each of the DSI/E threads in different rows of the admin who output.
  4. Configure modules such as distributed application of transactions in DSI and parallel processing in DIST.
Parent topic: Control the Number of Worker Threads