Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.


Chapter 7 Administering Message Queues and Mbox Sets : Using SWDIR\util\swadm to Administer Mbox Sets, Message Queues and Messages : Show Messages in a Queue

Show Messages in a Queue
To display a summary list of all the iProcess messages that are currently in a queue, use the following command:
swadm show_messages queue_id|ALL [EXP] [-x]
where:
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.

 

 
 
The following command displays the same messages in the alternative format:

 
 

Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.