| Author |
Message
|
| vinay_s_s |
 Posted: Mon Feb 09, 2009 4:08 am Post subject: Local queue application details. |
 |
|
Apprentice
Joined: 17 Nov 2008
Posts: 39
|
Hi Team,
How can we find out the list of applications connected to any local queue?
Not the queue manager application connections.
Also, I need to save this list to a text/xls file. Is this possible?
Thanks in advance,
Vinay |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Feb 09, 2009 4:27 am Post subject: Re: Local queue application details. |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vinay_s_s wrote: |
| How can we find out the list of applications connected to any local queue? |
The DISPLAY command shows the pids. The Search Function Is Your Friend.
Though pedantically I must point out applications connect to a queue manager not a queue
| vinay_s_s wrote: |
| Not the queue manager application connections. |
That's easy - the number of applications connected to a queue but not to a queue manager is zero. See above.
| vinay_s_s wrote: |
| Also, I need to save this list to a text/xls file. Is this possible? |
Of course. What possible use is it?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| vinay_s_s |
| Posted: Mon Feb 09, 2009 4:37 am Post subject: |
|
|
Apprentice
Joined: 17 Nov 2008
Posts: 39
|
Currently we are testing application connections to a particular queue.
We are able to see the application in the list of application connections of the queue manager.
However, there are many instances of the same application in the queue manager application details. We need to find out which connection is using which queue.
And these details are required to be saved on a text file for audit purpose.
Warm Regards,
Vinay |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Feb 09, 2009 4:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vinay_s_s wrote: |
| And these details are required to be saved on a text file for audit purpose. |
That has to be one of the more bizzarely pointless audit requirements I've heard. Aside from being a list for an auditor to admire (which is often the justification) what useful information does this contain? 
Oh well. If it was me, I'd tell the auditors to sit in a corner and be quiet, then build what they want, which I suspect is not what they've asked for.
But it's not me. And I accept the value of the "anything for the quiet life" philosophy. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| exerk |
| Posted: Mon Feb 09, 2009 4:52 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
As my esteemed colleague pointed out, each application instance will have a PID, therefore the PID of the application instance will also show on the queue when you display its status. A bit if scripting will do the rest.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Feb 09, 2009 5:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
More importantly, you are likely going about this entirely backwards.
The queues that an application will use should be determined at the time of designing the application,and they should be known and fixed during any given release of that application (they may change over the life of the application).
The application should then only be granted the necessary and sufficient priviledges it needs to those queues and no others, such that the list of queues that the application CAN connect to is the same as the list of queues that it NEEDS to connect to.
If you are attempting to produce this kind of design documentation from the infrastructure level, then you should at *least* be talking to the app teams. |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Feb 09, 2009 5:38 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
M071 or MQ explorer will show which applications have a queue handle on a given queue.
There is a MQSC version which can be easily redirected to a text file.
DISPLAY QSTATUS(XXXX) TYPE(HANDLE)
Last edited by zpat on Mon Feb 09, 2009 6:17 am; edited 1 time in total |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Mon Feb 09, 2009 5:45 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
If your qmgr is on z/OS, then SMF statistics and accounting records will provide this.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| vinay_s_s |
| Posted: Tue Feb 10, 2009 1:44 am Post subject: |
|
|
Apprentice
Joined: 17 Nov 2008
Posts: 39
|
Thanks a lot for your response and time. I managed to get it done by MO71.
Regards,
vinay |
|
| Back to top |
|
|
|
|
