| Author |
Message
|
| crossland |
 Posted: Fri Jul 01, 2011 1:07 am Post subject: Last message PUT/GET time and date |
 |
|
Master
Joined: 26 Jun 2001
Posts: 248
|
Is there any way to get last put date / last get date information for prior to the last queue manager restart?
A customer wants to see whether certain queues can be deleted as they may be redundant.
Last edited by crossland on Fri Jul 01, 2011 2:42 am; edited 1 time in total |
|
| Back to top |
|
 |
| shashivarungupta |
| Posted: Fri Jul 01, 2011 1:33 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
| crossland wrote: |
A customer wants to see whether certain queues can be deleted as they may be redundant. |
Which environment you are talking about, is that prod/uat ?
On the servers, queue manager objects are created followed by Change Request Or some Incident (depends on the business in that system). Server Qmgrs should have Only those queues that are as per the change requests or Incident.(MQ system defined objects are not for appl. usage)
*If the queues/any mq qmgr objs are there that are not in use Or risk to the security of the system, that were not mentioned in the CRs/Incident Records, can be deleted with Approval from Business/Appl. Teams.
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Fri Jul 01, 2011 1:38 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
@crossland
You should have created a *new* Post with your question(s) where old post could have been mentioned as a reference !
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| crossland |
| Posted: Fri Jul 01, 2011 2:15 am Post subject: |
|
|
Master
Joined: 26 Jun 2001
Posts: 248
|
| shashivarungupta wrote: |
If the queues/any mq qmgr objs are there that are not in use Or risk to the security of the system, that were not mentioned in the CRs/Incident Records, can be deleted with Approval from Business/Appl. Teams. |
In an ideal world, yes.
However, they have a VERY large number of MQ resource definitions and somebody there suspects that certain definitions are no longer in use. It would be great to say when the LASTPUTDATE and LASTGETDATE was, to demonstrate that the queues haven't been used for a long time (much longer than since the last queue manager restart). |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 01, 2011 2:19 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| If you want to see how old the messages on a queue are, use amqsbcg to dump the contents and look at the puttime and putdate. |
|
| Back to top |
|
|
| exerk |
| Posted: Fri Jul 01, 2011 2:27 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| crossland wrote: |
| ...It would be great to say when the LASTPUTDATE and LASTGETDATE was, to demonstrate that the queues haven't been used for a long time (much longer than since the last queue manager restart). |
It would be great indeed but unfortunately unless you have some historical tracking tool you won't get that out sort of information out of a queue manager. If the business is unsure of whether a queue is in use or not they should look at the application logs to see which queues are opened/closed by their applications and correlate that with the list of queues in the queue manager. If they do not log such information then PUT/GET disabling the ones they think are not used (with their cooperation and agreement of course) should identify which queues have message traffic, and those that do not. If the issue is one of their applications opening queues and issuing a get-with-wait then the disabling suggestion is a no-go and the application owners will need to supply a method of identifying 'used' queues and 'unused' queues, or you are going to have to switch on events and monitor over time to build up a trend report.
_________________
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 |
|
|
| exerk |
| Posted: Fri Jul 01, 2011 2:29 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| mqjeff wrote: |
| If you want to see how old the messages on a queue are, use amqsbcg to dump the contents and look at the puttime and putdate. |
Jeff, that presupposes there are messages. I think what crossland may be after is last put/get time/date on an empty queue.
_________________
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 |
|
|
| exerk |
| Posted: Fri Jul 01, 2011 2:30 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Splitting this post from the original...
_________________
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 |
|
|
| exerk |
| Posted: Fri Jul 01, 2011 2:32 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| shashivarungupta wrote: |
| ...Which environment you are talking about, is that prod/uat ? |
I'm not sure that's relevant - a clean-up is a clean-up.
_________________
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 |
|
|
| crossland |
| Posted: Fri Jul 01, 2011 2:35 am Post subject: |
|
|
Master
Joined: 26 Jun 2001
Posts: 248
|
| mqjeff wrote: |
| If you want to see how old the messages on a queue are, use amqsbcg to dump the contents and look at the puttime and putdate. |
That is a good suggestion as long as there are messages on the queue.
What I would prefer would be an option to persist the last put date / last get date values across a queue manager restart. |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Fri Jul 01, 2011 2:39 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
| exerk wrote: |
| shashivarungupta wrote: |
| ...Which environment you are talking about, is that prod/uat ? |
I'm not sure that's relevant - a clean-up is a clean-up. |
May Be, May be not., cause if that's hurting the system or not !
Generally management/business teams talk about 'cleanup' when there has been a long running problem for which they used temporary way out Or they suspect that something might cause the problem in the system due to *redundant* objects.
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Fri Jul 01, 2011 2:49 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
exerk, could you please remove my latest post from this old post and attach it here in this post by crossland.
(if thats possible)
Thanks for that.
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| exerk |
| Posted: Fri Jul 01, 2011 2:53 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| shashivarungupta wrote: |
exerk, could you please remove my latest post from this old post and attach it here in this post by crossland.
(if thats possible)
Thanks for that.
|
Please copy it and paste it into a new post on this thread, then I'll delete the other one - fail-safe way to ensure I don't lose it completely 
_________________
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 |
|
|
| shashivarungupta |
| Posted: Fri Jul 01, 2011 2:57 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
PostPosted: Thu Jun 30, 2011 10:32 pm Post subject:
| crossland wrote: |
| shashivarungupta wrote: |
If the queues/any mq qmgr objs are there that are not in use Or risk to the security of the system, that were not mentioned in the CRs/Incident Records, can be deleted with Approval from Business/Appl. Teams. |
In an ideal world, yes.
However, they have a VERY large number of MQ resource definitions and somebody there suspects that certain definitions are no longer in use. It would be great to say when the LASTPUTDATE and LASTGETDATE was, to demonstrate that the queues haven't been used for a long time (much longer than since the last queue manager restart). |
You can check what all mq objects ( Or queues in your case ) are in use at the *peak hours* of your business. And what are not being used, Identify them, filter out of those which are 'suspected' by 'somebody'.
(copied and pasted here from the old post, requesting to delete the same form old post, thanks exerk)
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
|
|
