Replication Server includes an enhancement to enable the distributor (DIST) thread to read SQL statements from the Stable Queue Thread (SQT) cache directly. This reduces contention between the inbound and outbound queues, and leads to improved Replication Server performance. Use the dist_direct_cache_read parameter with configure replication server to use this enhancement:
configure replication server set dist_direct_cache_read to ‘on’
By default, dist_direct_cache_read is set to ‘on’. If you disable the parameter, the distributor thread requests SQL statements from SQT through the message queue. This leads to inbound and outbound queue contention.
dist_direct_cache_read is a server-level static parameter. You must restart Replication Server after you enable or disable the parameter.
