Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Mercury
Participant
Posts: 6 Joined: Thu Jun 15, 2006 12:03 am
Post
by Mercury » Tue Jun 29, 2010 12:54 am
Hi, Is there a way to find the date/time of compilation of a job?
Thanks
udayk_2007
Participant
Posts: 72 Joined: Wed Dec 12, 2007 2:29 am
Post
by udayk_2007 » Tue Jun 29, 2010 1:07 am
you can usually see this information in DataStage Director
Regards
Ulhas
Mercury
Participant
Posts: 6 Joined: Thu Jun 15, 2006 12:03 am
Post
by Mercury » Tue Jun 29, 2010 1:19 am
udayk_2007 wrote: you can usually see this information in DataStage Director
Hmmm..true
But there's a limit to the number of messages retained in the log, so I don't find this info in the log..
Also, is there a way to know the date/time when a job was last modified?
Thanks
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Jun 29, 2010 1:25 am
While the DS_AUDIT hashed file contains information on the modification dates and times it doesn't store the compile time, in order to find that when the director log has been purged one would need to look into the appropriate RT_STATUS file - but the file structures for both DS_AUDIT and RT_STATUSnnn are not documented and are not readily accessible for the average DataStage user so it is not a simple answer.
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Tue Jun 29, 2010 10:56 am
Manager stores last modification time. Not sure if this gets updated after a compile.
Mamu Kim
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Tue Jun 29, 2010 2:40 pm
A very wild guess - can we say that the last modification time of RT_CONFIGnnn will be the last compilation time ?
I am off-site and do not have DataStage to check.