This illustration, which continues across two pages, shows the use case diagram Create a Queue Table in the AQ Administrative Interface.

To create a queue table, you must name the queue table. You must also specify the payload type as RAW or specify the payload type as an object type. To specify the payload type as an object type, you must define the object type.

Creating a queue table requires that you also do one of the following:

• Sort by enqueue time (default for sort time)
• Sort by priority
• Sort by enqueue time by priority
• Sort by priority by enqueue time

Additionally, you must either specify the single-consumer queue (default for multiconsumers), or specify the multiconsumer queue.

You must also specify message grouping as none (default), or specify message grouping as transactional.

You must specify the primary instance and the secondary instance. You must specify compatible as 8.0 (default if the database is in 8.0 compatible mode) or specify compatible as 8.1 (default if the database is in 8.1 or higher compatible mode).

Further, you may optionally:

• Specify the storage clause (specify only if you do not want to use the default tablespace)
• Add a table description (optional)
• Set auto-commit to true (default) or set auto-commit to false. Warning: These have been deprecated