If you are running Adaptive Server version 15.0.2 ESD #1 or later, you can query Adaptive Server for the following information about MQ objects on a specified queue manager by using the show option of the sp_msgadmin stored procedure:
The name of the queue manager
All queues and their queue types belonging to the queue manager
All channels and their types belonging to the queue manager
Preparing WebSphere MQ to use sp_msgadmin
'show'
In WebSphere MQ, start the queue manager that you want to make inquiries on.
Ensure that an MQ listener is running for the queue manager.
Start the command server of the queue manager.
Ensure that you have a queue called SYSTEM.ADMIN.COMMAND.QUEUE in the queue manager.
For information on how to perform these steps, see the documentation provided for WebSphere MQ at the IBM Publication Center.
