DSXchange

Hi,

Is there any way to extract Job Logfile from Datastage Director into a flatfile directly.


Thanks in Advance.

Yes. The easiest would be a DataStage job. Other methods use queries against the database capturing the output into a file using COMO, DIVERT.OUT or simple redirection.

Hi Ray,

Can you please explain me in brief, how to capture job logs into a flatfile through job. As i dont see any stage that captures logfile in server edition like in Parallel edition. Also i dont find any functions so called COMO & DIVERT.OUT in server edition can you please help me how to use them.

Thanks in Advance.

Check if the below link helps

viewtopic.php?t=98926

In server edition you can use Hashed File stage or UniVerse stage. The tricky part - discussed in the documents referred to - is determining the job number and therefore the hashed file name RT_LOGnnn.

Hi Major,

Thanks a lot. Link provided by you helped me to know how to extract Logfile from DataStage Director into FlatFile.

I'm an admin in our environment, we've informed our customers that they should automatically extract their job logs via "dsjob -logdetails..." command and archive them outside of the DataStage server (as we protect our production environment quite a bit). They FTP the log to a file server under their control.

For late night log sending, we just open it in director and print to file, then email it out.