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
performance monitoring
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
![Question :?:](./images/smilies/icon_question.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: