Page 1 of 1

Accessing Log files

Posted: Mon Nov 22, 2004 4:20 pm
by yaminids
Hello there,

Can anyone help me in storing the log files, generated in compilation, in a separate directory. I searched the archive and could not find a solution to my problem, eventhough I found some useful information. I would highly appreciate if someone could post their views here which I think would be highly useful to many members.
Also, am I supposed to install Universe server on the machine on which I installed DataStage server to access the log files.

Thanks in advance.
-Yamini

Posted: Mon Nov 22, 2004 7:08 pm
by ray.wurlod
The log files are NOT FILES - they are database tables.

You can use regular queries on the DataStage server machine; you do not need UniVerse installed.

Search also for a routine called ArchiveLogFiles which was published years ago - you're not the first to have this requirement.

Re: Accessing Log files

Posted: Mon Nov 22, 2004 8:14 pm
by chulett
yaminids wrote:Can anyone help me in storing the log files, generated in compilation, in a separate directory.
The confusing part to me is the 'generated in compilation' part of that sentence. :? It doesn't mean the normal log files from when the job runs to me... but that could just be me.

Perhaps the OP is after something different?

Posted: Mon Nov 22, 2004 8:17 pm
by ray.wurlod
There's no log file for that, on either the client or the server.

Output from the compiler on stdout and stderr is redirected to the connection to the client.

Accessing Log files

Posted: Tue Nov 23, 2004 11:29 am
by yaminids
Hello Ray,

Thank you for your reply. Now, I clearly understand about the log tables. Is there any way to redirect these log tables into a particular directory.

Thanx in advance.
-Yamini

Posted: Tue Nov 23, 2004 3:53 pm
by ray.wurlod
No.

Posted: Tue Nov 23, 2004 6:00 pm
by kduke
I think what they want is to archive logs to some kind of flat file. There have been several solutions posted even recently. Do a search for RT_LOG and archive.

Posted: Tue Nov 23, 2004 6:53 pm
by vmcburney
You can redirect the entire project to another directory. When you create a project in the Administrator you are prompted for a location. This would locate all the metadata and log files for that project to a new location and seperates the static part of your DataStage server - the software, from the dynamic part - the projects.