Commands to Configure Stable Queue Cache Parameters

Examples of stable queue cache parameters and the commands that you can use to configure them.

Example 1

Set the server-wide caching default value using:

configure replication server set sqm_cache_enable to
"on|off"

Example 2

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

alter queue q_number, q_type, 
  set sqm_cache_enable to "on|off"

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

Example 3

Set the server-wide page size default value using:

configure replication server set sqm_page_size to
"num_of_blocks"

Example 4

Set the page size for a specified queue using:

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 Replication Server. For example, if you set the page size to 4, this instructs the Replication Server to write to stable queue in 64K chunks.

Example 5

Set the server-wide cache size default value using:

configure replication server set sqm_cache_size to
"num_pages"

Example 6

Set the cache size for a specified queue using:

alter queue q_number, q_type, set sqm_cache_size to
"num_pages"

num_pages specifies the number pages in the cache.

All SQM configuration commands are static, thus you must restart the server for these commands to take effect. See the Replication Server Reference Manual for detailed information about these configuration parameters.