Configure Stable Queue Cache Parameters

All SQM configuration commands are static, thus you must restart the server for these commands to take effect.

See the Reference Manual for detailed information about these configuration parameters.

Enable Stable Queue Cache

Set the server-wide caching default value:

configure replication server 
set sqm_cache_enable to {on|off}

Enable or disable the caching for a queue and override the server-level setting:

alter queue q_number, q_type, 
set sqm_cache_enable to {on|off}

When sqm_cache_enable parameter is disabled, SQM module returns to the earlier mechanism, which maintains a fixed 16K; one-block buffer.

Set Stable Queue Cache Size

Set the server-wide cache size default value:

configure replication server 
set sqm_cache_size to "num_pages"

Set the cache size for a specified queue:

alter queue q_number, q_type,
set sqm_cache_size to num_pages

num_pages specifies the number pages in the cache.

Set Page Size for Stable Queue Cache

Set the server-wide page size default value:

configure replication server 
set sqm_page_size to "num_of_blocks"

Set the page size for a specified queue:

alter queue q_number, q_type,
set sqm_page_size to "num_of_blocks"

num_of_blocks specifies the number of 16K blocks in a page. Configuring the page size also sets the I/O size of SAP Replication Server. For example, if you set the page size to 4, this instructs the SAP Replication Server to write to stable queue in 64K chunks.

Ensure SQM Reader Reads All Commands in Cache

Set the server-wide setting to ensure the SQM reader always reads all commands from the stable queue manager cache.

configure replication server
set sqm_reader_first to "{on | off}"

Enable or disable the setting for a queue and override the server-level setting:

alter queue, q_number, q_type,
set sqm_reader_first to "{on | off}"