REG : Writing Logs From Director to Sequential File

Vinodanand · Post by **Vinodanand** » Mon Mar 13, 2006 8:30 am

Hi,

Can any one lemme knw whether we can write the director logs for all the jobs in a project to a flat file . If so how...

ArndW · Post by **ArndW** » Mon Mar 13, 2006 8:35 am

Vindodand,

I assume you mean "let me know" when you posted "lemme knw". There are two main ways to do this and both involve a bit of work. If you like shell or batch programming then you can use the "dsjob" executable to get a list of jobs in the project and then list out their log file contents, you can then capture that output in a sequential file.
The other method is similar, except you would do this from within a DataStage BASIC routine or job.

Which way are you looking at doing this?

Vinodanand · Post by **Vinodanand** » Mon Mar 13, 2006 8:38 am

ArndW wrote:Vindodand,

I assume you mean "let me know" when you posted "lemme knw". There are two main ways to do this and both involve a bit of work. If you like shell or batch programming then you can use the "dsjob" executable to get a list of jobs in the project and then list out their log file contents, you can then capture that output in a sequential file.
The other method is similar, except you would do this from within a DataStage BASIC routine or job.

Which way are you looking at doing this?

\

Arnd,

I'm kinda new to DS Coding so i'm not sure which one is efficient enough ... It wld be gr8 if u cld help me out on this... Thnx 4 ur prompt rep...

ArndW · Post by **ArndW** » Mon Mar 13, 2006 8:42 am

Vinod,

unless you are using DSXchange from your telephone or other PDA without a full keyboard, I would be very appreciative if you could write

Code: Select all

It would be great if you could help me out on this... Thanks for your prompt reply

instead of

It wld be gr8 if u cld help me out on this... Thnx 4 ur prompt rep"

Neither of us is a native English speaker and it makes it much easier to read when we don't text at each other, and the saving in keystrokes is not that much in comparison to the understandability.

I did ask you which method you feel more comfortable with - doing it from outside of DataStage inside a shell script or from inside of DataStage with DS/Basic?

Vinodanand · Post by **Vinodanand** » Mon Mar 13, 2006 8:52 am

ArndW wrote:Vinod,

unless you are using DSXchange from your telephone or other PDA without a full keyboard, I would be very appreciative if you could write
Code: Select all
It would be great if you could help me out on this... Thanks for your prompt reply
instead of
It wld be gr8 if u cld help me out on this... Thnx 4 ur prompt rep"
Neither of us is a native English speaker and it makes it much easier to read when we don't text at each other, and the saving in keystrokes is not that much in comparison to the understandability.

I did ask you which method you feel more comfortable with - doing it from outside of DataStage inside a shell script or from inside of DataStage with DS/Basic?

Arnd,

Sure I will make it a point to key in words at full here on. I feel DS Basic shld be comfortable . I am not that gr8 in DS Basic but I think i can understand stuff a bit .

ArndW · Post by **ArndW** » Mon Mar 13, 2006 9:06 am

I started to put a shell program together and then realized that certainly this has already been described - click here to the get FAQ answer to your question.

kcbland · Post by **kcbland** » Mon Mar 13, 2006 9:08 am

The DS APIs are documented in your manuals, consider DSGetLogSummary and such. The command line dsjob is also well documented. How about you experiment with both? dsjob is really is to use, but the APIs give you more flexibility but require more programming. dsjob is easily used with a ksh or perl script but has less functionality.

Vinodanand · Post by **Vinodanand** » Mon Mar 13, 2006 9:08 am

ArndW wrote:I started to put a shell program together and then realized that certainly this has already been described - click here to the get FAQ answer to your question.

Hi,

I tried logging in and it says the topic requested does not exist...

chulett · Post by **chulett** » Mon Mar 13, 2006 9:10 am

Worked fine for me...

ArndW · Post by **ArndW** » Mon Mar 13, 2006 9:11 am

Just click on the colored text, it should bring you straight to the post. At least it does when I cliock on it. You could also try browsing the FAQ for a subject titled "FAQ Suggestion: How can the director log be output to a file".

ray.wurlod · Post by **ray.wurlod** » Mon Mar 13, 2006 9:30 am

What's wrong with Print To File from Director's Project menu?

kduke · Post by **kduke** » Mon Mar 13, 2006 11:33 am

If people want to send me a DSX file where they have dumped the log to a table then please email it to me. I will add it to my links page.