Job LogFile

madhuker · Post by **madhuker** » Tue Dec 21, 2010 3:49 am

Hi,

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

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 21, 2010 4:44 am

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.

madhuker · Post by **madhuker** » Tue Dec 21, 2010 5:27 am

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.

major · Post by **major** » Tue Dec 21, 2010 6:08 am

Check if the below link helps

viewtopic.php?t=98926

ray.wurlod · Post by **ray.wurlod** » Tue Dec 21, 2010 3:22 pm

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.

madhuker · Post by **madhuker** » Wed Dec 22, 2010 2:50 am

Hi Major,

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

PaulVL · Post by **PaulVL** » Thu Dec 23, 2010 11:46 am

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.