Hi,
Is there any way to extract Job Logfile from Datastage Director into a flatfile directly.
Thanks in Advance.
Job LogFile
Moderators: chulett, rschirm, roy
Job LogFile
Thanks & Regards
Madhuker
Madhuker
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
Thanks & Regards
Madhuker
Madhuker
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
For late night log sending, we just open it in director and print to file, then email it out.