Copyright © Cloud Software Group, Inc. All rights reserved. |
• queue_id is the unique identifier of the queue you want to view messages for. You can find a queue’s identifier using the show_queues command. Enter ALL to show the messages in all queues.
• EXP is an optional parameter used with Oracle databases only. Use it to show all the Oracle exception messages. If this parameter is not specified, show_messages when used on an Oracle system will only list normal messages, with other types of database it will show all the messages.
• -x is an optional parameter that changes the format in which messages are displayed. If this parameter is specified, one message is displayed per line and fields in the message are separated by '|' characters.The following example (for Windows/SQL Server) lists all the messages in the DEADQUEUE queue. (The show_queues command is used first to identify the DEADQUEUE’s queue_id, which is 5.) In this case the DEADQUEUE contains just a single RELEASE instruction that has failed to be processed.
Copyright © Cloud Software Group, Inc. All rights reserved. |