Hi,
Has anyone come across an issue related to time differences between -logsum and -logdetail commands in a dsjob command line execution?
I ran a -logsum command and obtained the following:
Command: dsjob -server xyz -user xyz -password xyz -logsum ProjectName JobName
Result:
.
.
.
635 STARTED Thu Aug 12 04:46:35 2004
Starting Job LDWE72AI. (...)
.
.
.
Tha I ran a -logdetail command and obtained the following:
Command: dsjob -server xyz -user xyz -password xyz -logdetail ProjectName JobName 635
Result:
.
.
.
Event Id: 635
Time : Thu Aug 12 05:46:35 2004
Type : STARTED
User : xyz
Message :
Starting Job JobName.
.
.
.
Why the discrepancy of exactly 1 hour between the logsum and logdetail? They should be exactly the same... . And this happens in both development and production servers. Any hints?
Thanks & regards to you all...
Henrique
Time difference between logsum and logdetail?
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 25
- Joined: Wed Apr 09, 2003 12:58 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you please look at the log in Director log view and tell us which timestamp is reported in the detail view?
Note the event number. Connect to TCL (Administrator client Command window, or telnet session into DataStage). Execute the following querywhere nnn is the job number (from DS_JOBS) and n is the event number.
Note the event number. Connect to TCL (Administrator client Command window, or telnet session into DataStage). Execute the following query
Code: Select all
SELECT @ID, SEVERITY, TIMESTAMP FROM RT_LOGnnn WHERE @ID = n;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 25
- Joined: Wed Apr 09, 2003 12:58 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This shows that the timestamp actually in the log (it's stored as a Char(19)) is the same as the one dsjob reports with -logsum.
Something is adding one hour when using -logdetail. It does kinda look like a daylight saving shift, but it does kinda look also like a bug.
Has anyone else reproduced this? Does the Director client do the same thing (that is, show different timestamps in summary and detail - double click the event to get the detail)?
Something is adding one hour when using -logdetail. It does kinda look like a daylight saving shift, but it does kinda look also like a bug.
Has anyone else reproduced this? Does the Director client do the same thing (that is, show different timestamps in summary and detail - double click the event to get the detail)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.