Configuring Parallel Processing in the DIST Thread

Enable parallel processing in the distributor (DIST) thread.

Since the DIST thread reads transactions from the inbound queue, enable parallel processing at the primary SAP Replication Server. You can enable parallel processing in the DIST thread for specific connections to a primary database or for all primary database connections to SAP Replication Server.

  1. (Optional) Provide more worker threads for parallel processing in the DIST thread.
    1. Specify the number of worker threads.
      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.
  2. Enable parallel processing in the DIST thread.
    For a specific connection to a primary database, enter:
    alter connection to data_server.database
    set parallel_dist to on
    go
    At the server level for all primary databases connections to SAP Replication Server, enter:
    configure replication server
    set parallel_dist to on
    go
  3. Restart the DIST thread if you configured parallel_dist for a specific connection::
    suspend distributor data_server.database
    go
    resume distributor data_server.database
    go
    Restart SAP Replication Server for a server-level change.