Datastage Job logs for Today's/Yesterday's run

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Apy
Participant
Posts: 18
Joined: Fri Oct 14, 2016 6:26 am

Datastage Job logs for Today's/Yesterday's run

Post by Apy »

How I can get logs (Status alone will also work) for datastage jobs ran today/yesterday. Please note that jobs are running with invocation Id (Multiple instance jobs).
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The easiest way is to use DataStage Director client, which includes a Print option (and, from that, a Print to File option). Director can open separate invocations' logs separately.

If you want to use a programmatic approach, then you will need to organize the filtering by date and by invocation ID. But it's certainly doable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Apy
Participant
Posts: 18
Joined: Fri Oct 14, 2016 6:26 am

Post by Apy »

But Datastage Director client will also give the jobs which didn't ran today.
Basically I want to create a report in customized format and automate this process.
We can do this using dsjob command with -linvocations but this gives all invocation ids irrespective of date. I am just interested for a particular date not all.
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

What information are you obtaining from the log?
Perhaps the DSODB database can be your source of info.
Apy
Participant
Posts: 18
Joined: Fri Oct 14, 2016 6:26 am

Post by Apy »

As of now, I am interested in Job Start time, End time and Job status.
Please elaborate how I can access DSODB database to get this information. If possible, in detail please.
skathaitrooney
Participant
Posts: 103
Joined: Tue Jan 06, 2015 4:30 am

Post by skathaitrooney »

For DSODB connection information, give your DataStage admins a visit

How to use DSODB:
https://www.ibm.com/support/knowledgece ... ryodb.html
Post Reply