alter queue

Syntax

alter queue, q_number, q_type,
      set queue_param [to] "value"

Parameters

q_number – stable queue number
q_type – type of stable queue:
- 0 – outbound queue
- 1 – inbound queue
queue_param – a parameter that affects queues

value – a setting for queue_param

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

Examples

Example 1 – 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
```

Usage

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.

Permissions

alter queue requires "sa" permission.