alter queue
Specifies the behavior of the stable queue that encounters a large message that is greater than 16K bytes.
alter queue, <q_number>, <q_type>, set queue_param [to] "<value>"
Stable queue number
- Type of stable queue:
- 0 – outbound queue
- 1 – inbound queue
- A parameter that affects queues
-
A setting for <queue_param>
Table 1: Parameters Affecting Queues <queue_param> Description and <value> sqm_cache_enable
Enables or disables caching for the stable queue.
Enable: on
Disable: off
Default: on
Enabling the cache at the queue-level overrides any server-level cache that you set using configure replication server.
sqm_cache_size
Sets the stable queue cache size by specifying the number of pages in cache where the size of a page is specified by sqm_page_size.
Default: 16
The range is 1 to 4096
Enclose the number of pages in single quotes or double quotes.
Setting the cache size at the queue level overrides any server-level cache size that you set using configure replication server.
sqm_page_size
Sets the stable queue page size by specifying the number of 16KB blocks in a page.
Configuring the page size also sets the I/O size of SAP Replication Server. For example, setting page size to 4 instructs SAP Replication Server to write to the stable queue in 64K blocks.
Configuring the page size also sets the I/O size of Replication Server.
Enclose page sizes in single quotes or double quotes.
The range is 1 to 64.
Default: 4
Setting the page size at the queue level overrides any server-level page size that you set using configure replication server.
sqm_reader_first
Set sqm_reader_first on for a stable queue to ensure the stable queue manager (SQM) reader always reads all commands from the SQM cache.
Default: off
You must enable the SQM cache with sqm_cache_enable before you set sqm_reader_first to on.
You can also use configure replication server to set sqm_reader_first at the server level for all queues. Setting sqm_reader_first at the queue level overrides any server-level setting that you set.
See Ensuring SQM Reader Reads All Commands in Cache in the Administration Guide Volume 2 to configure sqm_reader_first.
sqm_xact_with_large_msg {skip | shutdown}
Specifies whether the SQM should skip the message or shut down, when a message larger than 16K bytes is encountered
- Shuts down queue number 2 if a large message is passed to the queue:
alter queue, 2, 0, set sqm_xact_with_large_msg to shutdown
If you make changes to the sqm_cache_enable, sqm_page_size, and sqm_cache_size parameters, restart the server for the changes to take effect.
alter queue fails if the site version is 12.5 or later.