performance monitoring

yimwai · Post by **yimwai** » Tue Jun 16, 2015 2:36 am

is there any way to fetch all the run logs of all the jobs with a project.
is there any way to fetch all the workload of each stage within the job.
The mainly information I need are:
1.start/end time
2.elapsed time
3.rows/sec
4.number of rows

The information is very similar with what we see from Director->tools->new monitor
I just want to batch fetch all the jobs's monitor information.
I'm thinking of directly fetch from metadata database?Could any one provide related table and columns.
Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Jun 16, 2015 3:46 am

If you are using the DataStage Operations Console then all these data are being automatically collected and stored in the DataStage Operations database (DSODB). The structure of this database is completely documented, so you should be able report directly from it.

chulett · Post by **chulett** » Tue Jun 16, 2015 6:59 am

So why is this topic marked as "Not resolved but there is a workaround" - are we done discussing it? You've gotten everything you need from it? Ray's answer isn't any kind of a "workaround", it is one of the resolutions to your question.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 16, 2015 4:20 pm

The workaround was marked before I posted.