Page 1 of 1

Accessing DataStage Logs

Posted: Wed Jun 11, 2008 2:13 am
by ag_ram
Hi All,

We are having a requirement to extract the logs which DataStage generates in the Director.

Our architecture design comples us to send the log for the job (in case of failure) as a payload to some generic logging service which inturn would log these details.

Our concern here is how can we access the DataStage logs from the job, extract it and then send it to the generic logging service.

Any inputs on the above would be really helpful.

Posted: Wed Jun 11, 2008 2:23 am
by WoMaWil
Hi Ram,

there a several ways to do it:

one is to write a job, which writes the (whole) log or selected entries into a file/table.

You can use "dsjob" (see manual) on the dataStage-Server-Machine, which can be called by a unix-shell-script or (on Windows-Servers) a Batch-Script.

Posted: Wed Jun 11, 2008 6:50 am
by chulett
Yah, as noted there are many ways to accomplish this and they've all been discussed here. Ad Nauseum. :wink:

Searching the forums for things like ETLStats, any of the 'DSGetLog' functions or 'dsjob' will turn them up. Then you need to decide on your preferred methodology - via DataStage jobs and/or custom routines or a scripted approach outside of the DataStage GUI.