| Author |
Message
|
| kodiakk |
 Posted: Tue Jul 05, 2016 7:44 am Post subject: Time/Date on messages in queue are about 4 hours ahead. |
 |
|
Acolyte
Joined: 04 Dec 2007
Posts: 58
Location: Jacksonville, Fl.
|
Good morning!
I'm using MQ version 7.0.1.6, and I'm finding that messages being placed into our queues are 4 hours ahead of local time. For example, today, a message was placed in one of our *.ERROR queues, and it shows a time stamp of July 5, 2016, 2:19:06 PM. The ACTUAL time, of course, was 10:19 AM, which matched the time on the server.
Obviously, this has to do with the way MQ was installed on this system, and someone didn't account for us not being on GMT...
Where can I find the setting responsible for this? Do I have to re-install MQ in order to fix it?
It's becoming problematic, now, after years of being this way, because we are now trying to locate specific pieces of data within the messages for problem determination purposes, and getting an accurate time for the message would expedite matter significantly.
Obviously, it's not hard to do the math and subtract 4 from the current time, but that won't really hold up under an audit, so we'd like to change this parameter if at all possible.
Thanks in advance for any help that you can provide.
_________________
"Don't take life too seriously... you won't get out of it alive..." |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Jul 05, 2016 7:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I'm guessing you're 4 hours behind GMT.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| kodiakk |
| Posted: Tue Jul 05, 2016 7:52 am Post subject: |
|
|
Acolyte
Joined: 04 Dec 2007
Posts: 58
Location: Jacksonville, Fl.
|
Eastern time zone, yes. 
_________________
"Don't take life too seriously... you won't get out of it alive..." |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jul 05, 2016 7:56 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
so everything is fine then?
MQ by design uses GMT/UTC+0 for all message timestamps.
Very useful when sending data around the world.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| kodiakk |
| Posted: Tue Jul 05, 2016 8:00 am Post subject: |
|
|
Acolyte
Joined: 04 Dec 2007
Posts: 58
Location: Jacksonville, Fl.
|
Well... fine, in that it's doing GMT+0 but we'd really like GMT-4... that way, the MQ item can correctly correspond with the transaction we're searching for... Auditors will look at the 4 hour time difference and ask "How do you know that's the right one? It doesn't correlate with the time of the transaction."
Of course, at that point, we'd have to explain GMT+0 vs. GMT-4... and auditors don't like explanations. 
_________________
"Don't take life too seriously... you won't get out of it alive..." |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jul 05, 2016 8:01 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Change whatever you're using to show messages to convert GMT to EDT... 
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| kodiakk |
| Posted: Tue Jul 05, 2016 8:02 am Post subject: |
|
|
Acolyte
Joined: 04 Dec 2007
Posts: 58
Location: Jacksonville, Fl.
|
I'm just using the BROWSE MESSAGE function in MQ... that's why I'm asking to see if there's a setting I can change within MQ itself.
_________________
"Don't take life too seriously... you won't get out of it alive..." |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jul 05, 2016 8:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can't convert the MQMD to use a different timezone.
You can modify and recompile amqsbcg...
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Jul 05, 2016 9:35 am Post subject: Re: Time/Date on messages in queue are about 4 hours ahead. |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| kodiakk wrote: |
Obviously, it's not hard to do the math and subtract 4 from the current time, but that won't really hold up under an audit, so we'd like to change this parameter if at all possible.
Thanks in advance for any help that you can provide. |
GMT won't pass audit?? Really. Your auditors told you this? Does your organization use any DBs?
_________________
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 |
|
|
| gbaddeley |
| Posted: Tue Jul 05, 2016 5:55 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| kodiakk wrote: |
Well... fine, in that it's doing GMT+0 but we'd really like GMT-4... that way, the MQ item can correctly correspond with the transaction we're searching for... Auditors will look at the 4 hour time difference and ask "How do you know that's the right one? It doesn't correlate with the time of the transaction."
Of course, at that point, we'd have to explain GMT+0 vs. GMT-4... and auditors don't like explanations. |
The simple explanation to the auditors is that MQ stores MQMD putdate/time stamps in GMT. As do many other s/w products....
The only way around this is to set the system clock to local time and set the system time zone to +0. Of course this will affect nearly everything on the system, and play havoc with interfacing systems.
_________________
Glenn |
|
| Back to top |
|
|
| PaulClarke |
| Posted: Tue Jul 05, 2016 6:17 pm Post subject: |
|
|
Grand Master
Joined: 17 Nov 2005
Posts: 1002
Location: New Zealand
|
Kodiakk,
Surely the only way a timestamp means anything is to have a fixed point of reference. I would have thought the auditors would much prefer that. Otherwise seeing 6pm in a message is meaningless since it is always 6pm (the hour of) somewhere in the world. A useful thing to remember if you are trying to work out whether it is too early for a beer.
The thing to do is to change the way the message is displayed rather than the content of the message. Our MO71 product, for example, allows you to display these times, when you browse a queue, in local time if you prefer.
Cheers,
Paul.
_________________
Paul Clarke
MQGem Software
www.mqgem.com |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jul 05, 2016 10:12 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| kodiakk wrote: |
Of course, at that point, we'd have to explain GMT+0 vs. GMT-4... and auditors don't like explanations. |
In my experience, Auditors don't like explanations that can't be backed up with facts.
I am sure the MQ docs have an explanation of this.
Just point the auditors at that and say,
"Thats the way the product works."
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Wed Jul 06, 2016 6:13 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| kodiakk wrote: |
| ... auditors don't like explanations. |
This https://www.ibm.com/support/knowledgecenter/SSFKSJ_8.0.0/com.ibm.mq.ref.dev.doc/q097640_.htm
[url] says this:
| Quote: |
| Greenwich Mean Time (GMT) is used for the PutDate and PutTime fields, subject to the system clock being set accurately to GMT. |
No other explanation needed.
_________________
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 |
|
|
|
|
