DSXchange

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

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.

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.

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 ...

How can we get the log info with Windows as OS. I am trying to view the log other than Director.

thanks
Nivas

The "dsjob" command is the same on Windows and UNIX. It can be called from either the server or the client.

Same answer for Windows.

chulett wrote:Same answer for Windows.

I am trying to find how do I read from output stream to a file in DOS. The following I am getting.

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

"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum"

ArndW wrote:"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum" ...

Excellent.

Thanks
Nivas

You'll need to redirect the output for the 'to a file' part, which means adding " > filenname" or perhaps " >> filename" to the end of the command.

Thank you very much for all.
Nivas