DataStage version is 8.1 - I have no direct access but need to give instructions to extract some job runtime stats for me. I believe that repository is in DB2 database or maybe in flat files if that's still supported in 8.1. I can't install any tools there.
There is a master sequence with few dozen jobs. Some of them are parallel. The sequence itself runs one at a time and it runs constantly during the day.
For 24 hours period, I need to extract performance stats for this master sequence. Something like that:
job_name, start_time, finish_time, completion_status
I really just need timing info. I can work with any format but what I'm really after in the end is a csv-style file with timings as above.
I get some hints on dsjob -report but I don't have enough background in DataStage to provide good instructions. Hope to get access myself but again, I'm a noob at DataStage.
Thanks in advance.