Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
gpbarsky
Participant
Posts: 160 Joined: Tue May 06, 2003 8:20 pmLocation: Argentina
Post
by gpbarsky Thu May 29, 2008 9:47 am
Hi, my friends....
I'm looking a way to know each job modification date (server or sequencer).
If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date.
Is there a way to get the real job update date and time ?
Thanks in advance.
Guillermo P. Barsky
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pmLocation: Denver, CO
Post
by chulett Thu May 29, 2008 11:31 am
'Real' job update date/time? Depending on what that means, you could query the DS_AUDIT table in the repository for that I would think.
-craig"You can never have too many knives" -- Logan Nine Fingers
ag_ram
Premium Member
Posts: 524 Joined: Wed Feb 28, 2007 3:51 am
Post
by ag_ram Fri May 30, 2008 12:43 am
gpbarsky wrote: Hi, my friends....
What you need exactly?
Job Modification TimeStamp or Job Compilation TimeStamp
Job Modification TimeStamp - DS_AUDIT
Job Compilation TimeStamp - RT_CONFIGnnn(31th Field, in DataStage internal format)
ag_ram
Premium Member
Posts: 524 Joined: Wed Feb 28, 2007 3:51 am
Post
by ag_ram Fri May 30, 2008 12:43 am
gpbarsky wrote: Hi, my friends....
What you need exactly?
Job Modification TimeStamp or Job Compilation TimeStamp
Job Modification TimeStamp - DS_AUDIT
Job Compilation TimeStamp - RT_CONFIGnnn(31st Field, in DataStage internal format)
gpbarsky
Participant
Posts: 160 Joined: Tue May 06, 2003 8:20 pmLocation: Argentina
Post
by gpbarsky Fri May 30, 2008 8:07 am
Thanks, Ram and Craig.
Guillermo P. Barsky
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pmLocation: Denver, CO
Post
by chulett Fri May 30, 2008 8:26 am
It's not in the public domain, but you can do a 'LIST.DICT' on it or just a 'select * from' and see what you get.
-craig"You can never have too many knives" -- Logan Nine Fingers
gpbarsky
Participant
Posts: 160 Joined: Tue May 06, 2003 8:20 pmLocation: Argentina
Post
by gpbarsky Fri May 30, 2008 9:12 am
Thank you very much, Craig.
I'll try to develop the DS job to list the DS_AUDIT table. I know that this is not an easy task, but I will try.
Guillermo P. Barsky
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pmLocation: Denver, CO
Post
by chulett Fri May 30, 2008 9:25 am
You could also do a 'LIST.DICT DS_AUDIT' from the Administrator client. Search the forums for COMO to find ways to get that output in a file.
-craig"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pmLocation: Sydney, Australia
Contact:
Post
by ray.wurlod Fri May 30, 2008 3:45 pm
Tip: create/import a table definition with "metadata supports multi-valued fields" check box checked. Then use a UniVerse stage to extract from DS_AUDIT. Use two output links, one un-normalized and the other normalized on MODS.
IBM Software Services Group
