Page 1 of 1

how to Query XMETADATA Repository?

Posted: Tue Apr 10, 2012 12:31 pm
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?

Posted: Tue Apr 10, 2012 1:31 pm
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,