DSXchange

Posted: **Wed Nov 03, 2010 11:44 am**

Hi All,

I need to get all job information and load to the table can any one tel me how to parse the datastage log/DB.

Thanks in advance

Posted: **Wed Nov 03, 2010 11:55 am**

check

Code: Select all

dsjob -logsum

Posted: **Wed Nov 03, 2010 12:06 pm**

Hi Anbu
This we need to give on unix or in the before/after subroutine?

Posted: **Wed Nov 03, 2010 12:12 pm**

From Unix

Posted: **Wed Nov 03, 2010 12:17 pm**

Hi anbu
but how do do you fetch that in formation into a file

Posted: **Wed Nov 03, 2010 12:24 pm**

When you run the dsjob command from Unix, it will fetch you the info about the job. Just redirect output of the command to a file.

Check manual for complete syntax

Code: Select all

dsjob ... > file

Posted: **Wed Nov 03, 2010 12:52 pm**

Thanks Anbu i will try that

DSXchange

parse log

parse log