how to Query XMETADATA Repository?

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
Aquilis
Participant
Posts: 204
Joined: Thu Apr 05, 2007 4:54 am
Location: Bangalore
Contact:

how to Query XMETADATA Repository?

Post by Aquilis »

Hi All,

Is there any way that, information like number of records read, rejected, Job elapsed time, job start time and end time etc.. can be gathered directly from XMETA Data Repository?

Does XMETA stores these in it's DS repository?. If so, what would be possible query to fired to get all these.

What are all the object names which repository holds?

Seems Silly, But is it possible?

Advise, if possible or not?
Aquilis
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

It would not be easy and the XMETA datamodel is not published.

You can access the information through a DataStage BASIC routine, specifically the job control functions. DSAttachJob and DSGetJobInfo, DSGetStageInfo, DSGetLinkInfo are the ones of primary interest for you.

Documented here and in the IBM InfoSphere DataStage Programmer's Guide.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Post Reply