dsjob -report in xmeta database ?

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
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

dsjob -report in xmeta database ?

Post by kaps »

I am wondering if anyone know the table name in xmeta database ? I am aware that there are lot of tables in there and vendor does not want to make is easier wantedly but am wondering if anyone found that information. I am trying to get information such as Job Name, Job start time, Job end time and job status which we usually get from dsjob -report command. What is the best way to attain this info ?

Thanks in advance...
ghila
Premium Member
Premium Member
Posts: 41
Joined: Mon Mar 15, 2004 2:37 pm
Location: France

Re: dsjob -report in xmeta database ?

Post by ghila »

If using 8.7, you better have to install the Operations Console. It's based on a dedicated "open" database that is documented.

Regards
Daniel
Regards,

Daniel
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Post by kaps »

We do have Operations console but we would like to have them in a table. Are you familiar with the tables behind the Ooperations console ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Tables in the DSODB schema are open and documented. You can examine the scripts that create them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply