Difference in Server and Datastage Director Time
Moderators: chulett, rschirm, roy
Hi, Thanks a lot for reply.. Please see my answers in bold below:
[quote="PaulVL"]Look at your profile. - I did not setup anything in profile
Which user id are you loging in with via telnet? - My own user id.. I did an su to dsadm and executed sh -c date (from telnet) which shows correct time as well... Only director shows incorrect time
Is it the same user id that is executing datastage (dsadm) ?
Look at the profile of that ID. Are you setting your time zone?
How is the time on the server causing you an issue? we will use mainframe scheduler to run jobs
Are you relying upon the internal job scheduler to trigger jobs?
Are you extracting server time via a routine and using that to populate some of your date fields? - Yes, i am populating some database fields using a routine...
[quote="PaulVL"]Look at your profile. - I did not setup anything in profile
Which user id are you loging in with via telnet? - My own user id.. I did an su to dsadm and executed sh -c date (from telnet) which shows correct time as well... Only director shows incorrect time
Is it the same user id that is executing datastage (dsadm) ?
Look at the profile of that ID. Are you setting your time zone?
How is the time on the server causing you an issue? we will use mainframe scheduler to run jobs
Are you relying upon the internal job scheduler to trigger jobs?
Are you extracting server time via a routine and using that to populate some of your date fields? - Yes, i am populating some database fields using a routine...
ok, but you still have not answered the question: What issue are you facing?
At my site we use Mainframe CA7 scheduler.
Mainframe has a different timezone than my Linux servers.
No issues.
So... what is your concern with having a Unix server in Denver timezone?
Your personal user id is not the ID that your jobs would run under right?
Your personal ID most likely has an entry in your ".profile" to set your default timezone.
next time you "su other_id" do this: "su - other_id". That will source the profile I believe.
At my site we use Mainframe CA7 scheduler.
Mainframe has a different timezone than my Linux servers.
No issues.
So... what is your concern with having a Unix server in Denver timezone?
Your personal user id is not the ID that your jobs would run under right?
Your personal ID most likely has an entry in your ".profile" to set your default timezone.
next time you "su other_id" do this: "su - other_id". That will source the profile I believe.
Hi Paul,
I think I did not do a good job of explaining the issue... Will try one more time...
Time Zone/Time on UNIX Server (from telnet) is accurate (EDT American/New York)...
Problem is that the Time Zone when viewed from Director/Administrator is correct whereas the actual time from Director/Administrator is advanced by 4 hrs... When I execute 'sh -c date' at director command prompt, it says EDT America/New York, which is fine, but it shows the time as 17:00 when the actual time is 13:00...
My UNIX admin just confirmed that both time zone and time on server are correct (from root profile)... but he has no clue why datastage has correct time zone (EDT America/New York) but incorrect time...
As I said, I am populating some database fields using routines so its kind of must for DataStage to fetch correct times...
Thanks a lot for your help,
Kiran
I think I did not do a good job of explaining the issue... Will try one more time...
Time Zone/Time on UNIX Server (from telnet) is accurate (EDT American/New York)...
Problem is that the Time Zone when viewed from Director/Administrator is correct whereas the actual time from Director/Administrator is advanced by 4 hrs... When I execute 'sh -c date' at director command prompt, it says EDT America/New York, which is fine, but it shows the time as 17:00 when the actual time is 13:00...
My UNIX admin just confirmed that both time zone and time on server are correct (from root profile)... but he has no clue why datastage has correct time zone (EDT America/New York) but incorrect time...
As I said, I am populating some database fields using routines so its kind of must for DataStage to fetch correct times...
Thanks a lot for your help,
Kiran
-
- Premium Member
- Posts: 87
- Joined: Mon Feb 18, 2008 3:58 pm
- Location: Sacramento, CA
You have appended your problem onto a posting created by Sreedhar. Did you try his solution in the post dated Mar 22, 2010 9:26 am? Sreedhar was our admin when he created this post and the solution he found fixed our issue which sounds just like the problem you are discribing. Of course, since you are in a different time zone, you wouldn't use the same setting; you would have to use the EDT setting.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 87
- Joined: Mon Feb 18, 2008 3:58 pm
- Location: Sacramento, CA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: