parse log

raji33 · Post by **raji33** » 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

anbu · Post by **anbu** » Wed Nov 03, 2010 11:55 am

check

Code: Select all

dsjob -logsum

raji33 · Post by **raji33** » Wed Nov 03, 2010 12:06 pm

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

anbu · Post by **anbu** » Wed Nov 03, 2010 12:12 pm

From Unix

raji33 · Post by **raji33** » Wed Nov 03, 2010 12:17 pm

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

anbu · Post by **anbu** » 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

raji33 · Post by **raji33** » Wed Nov 03, 2010 12:52 pm

Thanks Anbu i will try that