ALTER QUEUE

ALTER QUEUE

Syntax

alter_queue ::=

Description

ALTER QUEUE alters the definition of a queue.

COMPACT

This returns empty pages to the tablespace in which the queue is located. No data is actually moved.

MSGID RESET

This resets the queue's MSGID

DELETE [ON|OFF]

DELETE ON allows the use of the DELETE statement on a queue table. DELETE OFF disallows the use of the DELETE statement on a queue table. In this case, DEQUEUE performance improves compared to when DELETE is allowed.