MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TimeZONE

TimeZONE

« View previous topic :: View next topic »

Author

Message

SOLOHERO

Posted: Mon Oct 26, 2009 7:08 pm Post subject: TimeZONE

Centurion

Joined: 01 Feb 2007
Posts: 107

Hi All,

Code we are using for current time stamp with time zone: CURRENT_TIMESTAMP AS CHAR FORMAT 'yyyy-MM-dd''T''HH:mm:ssZZZ

The code on windows returns time zone

eg. 2009-10-22T15:16:41+11:00 (what we are expecting)

The code on AIX returns time zone

eg. 2009-10-22T15:22:15+03:00

Question:

Why is the timezone in AIX box different. Is there a fix pack for this, if so what is the fix pack number for AIX ?

Thanks in Advance
_________________
Thanks

fjb_saper

Posted: Mon Oct 26, 2009 8:48 pm Post subject: Re: TimeZONE

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

SOLOHERO wrote:

What is the TZ set in mqsiprofile?
What is the TZ set in the service user profile?

Enjoy

_________________
MQ & Broker admin

SOLOHERO

Posted: Mon Oct 26, 2009 9:03 pm Post subject:

Centurion

Joined: 01 Feb 2007
Posts: 107

How do i check that in AIX box...
_________________
Thanks

Vgowda

Posted: Mon Oct 26, 2009 9:15 pm Post subject:

Acolyte

Joined: 11 Dec 2007
Posts: 61
Location: Bengaluru

I dont think there is a problem with broker. Better check out whether the TimeZone in both the machines ( Windows and AIX) are matching or not manually.
_________________
Regards
Vinay

fjb_saper

Posted: Mon Oct 26, 2009 9:18 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

SOLOHERO wrote:

How do i check that in AIX box...

Look up the TZ command.
_________________
MQ & Broker admin

SOLOHERO

Posted: Mon Oct 26, 2009 10:05 pm Post subject:

Centurion

Joined: 01 Feb 2007
Posts: 107

I dont think it is the timezone setting in AIX box..cause i tried the following code

SET OutputRoot.XMLNS .CreationTime = CAST(CURRENT_TIMESTAMP AS CHAR FORMAT 'yyyy-MM-dd''T''HH:mm:ssZZZ');
SET OutputRoot.XMLNS. CurrentGMTTimeStamp= CURRENT_GMTTIMESTAMP;
SET OutputRoot.XMLNS. CurrentGMTTime= CURRENT_GMTTIME;
SET OutputRoot.XMLNS. CurrentTimeStamp = CURRENT_TIMESTAMP;
SET OutputRoot.XMLNS. CurrentTime= CURRENT_TIME;

Output on AIX system:

<ctx:CreationTime>2009-10-27T16:47:00+02:00</ctx:CreationTime>
<ctx:CurrentGMTTimeStamp>2009-10-27 05:47:00.118093</ctx:CurrentGMTTimeStamp>
<ctx:CurrentGMTTime>05:47:00.118093</ctx:CurrentGMTTime>
<ctx:CurrentTimeStamp>2009-10-27 16:47:00.118093</ctx:CurrentTimeStamp>
<ctx:CurrentTime>16:47:00.118093</ctx:CurrentTime>

The time zone in set to australian standard on AIX box...but the zone comes as +02:00.

Same Code on Windows system:

<ctx:CreationTime>2009-10-27T16:59:28+11:00</ctx:CreationTime>
<ctx:CurrentGMTTimeStamp>2009-10-27 05:59:28.546964</ctx:CurrentGMTTimeStamp>
<ctx:CurrentGMTTime>05:59:28.546964</ctx:CurrentGMTTime>
<ctx:CurrentTimeStamp>2009-10-27 16:59:28.546964</ctx:CurrentTimeStamp>
<ctx:CurrentTime>16:59:28.546964</ctx:CurrentTime>

Thanks in advance
_________________
Thanks

fjb_saper

Posted: Tue Oct 27, 2009 3:16 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

SOLOHERO wrote:

You told us what the broker returns. You did not tell us what the OS (AIX) returns for the broker's service user, before and after you run mqsiprofile....

check out the date and TZ commands for the OS.

_________________
MQ & Broker admin

SOLOHERO

Posted: Tue Oct 27, 2009 3:25 pm Post subject:

Centurion

Joined: 01 Feb 2007
Posts: 107

$ date -u +"%x""%T""%Z"
10/27/0923:22:55GMT
$ date
Wed Oct 28 10:23:57 EETDT 2009

This looks right time Settings in AIX

Thanks
_________________
Thanks

fjb_saper

Posted: Wed Oct 28, 2009 5:10 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

So now we know the TZ for the OS. What is the TZ declared for the broker?
Do they conflict?

_________________
MQ & Broker admin

SOLOHERO

Posted: Wed Oct 28, 2009 9:15 pm Post subject:

Centurion

Joined: 01 Feb 2007
Posts: 107

Looks like the problem is with broker on AIX.

I changed the timezone to be EDT-10EETDT,M10.1.0/02:00,M4.1.0/03:00 instead of EET-10EETDT,M10.1.0/02:00,M4.1.0/03:00, and broker now displays correct time.

based on our test, it appears that broker takes the first 3 characters of TZ and take it the time zone, and it ignores the UTC offset.

the issue is AIX sees EET as Australian Eastern Time, but broker sees EET Eastern European time.

Did any one of had a issue like this.......
_________________
Thanks

smdavies99

Posted: Thu Oct 29, 2009 2:08 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

I Think that:-

Austrailian Eastern Standard Time should be AEST

EET is indeed Eastern European Time.

http://www.timeanddate.com/library/abbreviations/timezones/

gives a list of them.
_________________
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.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TimeZONE

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP