alter queue

Description

Specifies the behavior of the stable queue that encounters a large message of greater than 16K bytes. Applicable only when the Replication Server version is 12.5 or later and the site version is 12.1 or earlier.

Syntax

alter queue, q_number, q_type, set sqm_xact_with_large_msg [to]
	{skip | shutdown}

Parameters

q_number: The queue number of the stable queue.

q_type: The queue type of the stable queue. Values are “0” for outbound queues and “1” for inbound queues.

sqm_xact_with_large_msg {skip | shutdown}: Specifies that the SQM should skip or shut down when encountering a message larger than 16K bytes.

Examples

Example 1

Specifies that outbound queue #2 shuts down if it is passed a large message:

alter queue, 2, 0, set sqm_xact_with_large_msg to
    shutdown

Usage

alter queue fails if the site version is 12.5 or later.

Permissions

alter queue requires "sa" permission.