Log Path to see the Job LOG - not thru Director!!!
Moderators: chulett, rschirm, roy
Log Path to see the Job LOG - not thru Director!!!
Hi,
My Director is not able to show a particular job log , may be it is too big to load.
Is there a way to look at the Job Log in Unix? , not thru Director.
if so where do i look for job log in Ascential path?
Thanks
My Director is not able to show a particular job log , may be it is too big to load.
Is there a way to look at the Job Log in Unix? , not thru Director.
if so where do i look for job log in Ascential path?
Thanks
The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redirect that to a text file.
Addendum - I should have read the whole post before replying, after seeing Rays's response I realize that I answered a question that really wasn't asked.
Addendum - I should have read the whole post before replying, after seeing Rays's response I realize that I answered a question that really wasn't asked.
Last edited by ArndW on Wed May 28, 2008 10:58 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I suspect you are just being impatient. To retrieve the job log, a request of the form SELECT * FROM RT_LOGnnn WHERE ... ORDER BY 1 must be issued against the Repository database. If there are many entries in the log table, sorting the report will take quite some time. No rows can be returned until the sorting has been completed. That's why we endeavour to keep logs small.
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.
How can we get the log info with Windows as OS. I am trying to view the log other than Director.ArndW wrote:The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redi ...
thanks
Nivas
I am trying to find how do I read from output stream to a file in DOS. The following I am getting.chulett wrote:Same answer for Windows.
C:\ASCENT~1\DATAST~1\Engine\bin>dsjob -log HSNOUB92Warehouse BatchHSNOCHCWarehou
se1
Enter message text, terminating with Ctrl-d
Nivas^D
Message read.
After this How do read the message or log to a file ?
thanks
Nivas
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: