Page 1 of 1
Accessing DS metadata
Posted: Tue Sep 04, 2007 4:56 am
by saikrishna
Hi
Can you please help me in providing the info about accessing DataStage proprietary database....
Thanks
Sai
Posted: Tue Sep 04, 2007 5:48 am
by kduke
Need more information. What do want to extract?
Posted: Tue Sep 04, 2007 5:54 am
by saikrishna
I want to see the status of the jobs that ran for a day in production environment... Like, the list of aborted jobs on a particular day...
And also, If you could share the info about the architecture of how DS stores it's metadata and details of the database that DS uses would be great help for us...
Thanks
Sai
Posted: Tue Sep 04, 2007 6:19 am
by WoMaWil
there a different types of META-Data in Datastage.
What you seem to be interested in are the processing informations as you find them for example in the logfile. These data are erased by the time. The best is to harvest them after each job run an write those you are interested in directly into you own database.
Posted: Tue Sep 04, 2007 7:57 pm
by kduke
You need to download EtlStats from my tips page. Follow the link on my signature.