Accessing DS metadata

saikrishna · Post by **saikrishna** » Tue Sep 04, 2007 4:56 am

Hi

Can you please help me in providing the info about accessing DataStage proprietary database....

Thanks
Sai

kduke · Post by **kduke** » Tue Sep 04, 2007 5:48 am

Need more information. What do want to extract?

saikrishna · Post by **saikrishna** » Tue Sep 04, 2007 5:54 am

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

WoMaWil · Post by **WoMaWil** » Tue Sep 04, 2007 6:19 am

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.

kduke · Post by **kduke** » Tue Sep 04, 2007 7:57 pm

You need to download EtlStats from my tips page. Follow the link on my signature.