queue_name
|
Name of the queue that is to be altered. |
max_retries
|
Limits the number of times a dequeue with REMOVE mode can be attempted on a message. The maximum value of max_retries is 2**31 -1.
The count is incremented when the application issues a rollback after executing the dequeue. If the time at which one of the retries has passed the expiration time, then no further retries are attempted. Default is NULL , which means that the value will not be altered.
Note that max_retries is supported for all single consumer queues and 8.1-compatible multiconsumer queues but not for 8.0-compatible multiconsumer queues. |
retry_delay
|
Delay time in seconds before this message is scheduled for processing again after an application rollback. The default is NULL , which means that the value will not be altered.
Note that retry_delay is supported for single consumer queues and 8.1-compatible multiconsumer queues but not for 8.0-compatible multiconsumer queues. |
retention_time
|
Retention time in seconds for which a message is retained in the queue table after being dequeued. The default is NULL , which means that the value will not be altered. |
auto_commit
|
TRUE : Causes the current transaction, if any, to commit before the ALTER_QUEUE operation is carried out. The ALTER_QUEUE operation become persistent when the call returns. This is the default.
FALSE : The operation is part of the current transaction and becomes persistent only when the caller enters a commit.
Caution: This parameter has been deprecated. |
comment
|
User-specified description of the queue. This user comment is added to the queue catalog. The default value is NULL , which means that the value will not be changed. |