How to load jobs log into table?

ray.wurlod · Post by **ray.wurlod** » Mon Jan 22, 2007 4:21 am

A job log can be accessed with a Hashed File stage or a UV stage. You can create DataStage jobs to move the data. Of course, this will involve a job sequence, because you have to generate the log file name (RT_LOGnnn, where nnn is the job number).

You could also use a Sequential File stage with dsjob -logsum as its filter command.

userasif · Post by **userasif** » Mon Jan 22, 2007 4:38 am

Thanks Ray..Most of the time you are first to reply me... But sorry I am not Premium Member and so cannot read your reply.....

Thanks a lot.

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 7:41 am

dsjob command has many options for logs. -logdetail, -logsum etc. Use that to get the log into a text file. You can then parse that text file to bring it into a delilmited file with all the information you need.

userasif · Post by **userasif** » Mon Jan 22, 2007 11:18 pm

Thanks for your prompt,

But I think this command is for UNIX sever.. am i right?????
Can any one tell me about Universe tables that hold jobs log that is Job Name, Start / End time and etc????????

Regards.

narasimha · Post by **narasimha** » Mon Jan 22, 2007 11:46 pm

No, these commands are not specific to UNIX.
Read the job logs to get the details you need.