Page 1 of 1

In which directory/file name on UNIX, the job log is stored?

Posted: Fri Aug 05, 2005 2:34 pm
by rickrambo
When I run a job thru director, I see the job log. In UNIX, which directory and what file name the job log stored?

Posted: Fri Aug 05, 2005 3:08 pm
by kduke
The log is stored in a hash file named RT_LOGnnn where nnn is the job number. Do a search there are lots of posts on how to retrieve this data.

Posted: Fri Aug 05, 2005 7:03 pm
by ray.wurlod
Note in particular that RT_LOGnnn is the name of a database table, not of a file that can be viewed with UNIX utilities. You need to employ a DataStage SQL query to examine it. Search the forum for techniques.
If you want it in a text file, use the File > Print option in Director.

Re: In which directory/file name on UNIX, the job log is sto

Posted: Tue Aug 16, 2005 3:44 pm
by jatinrheen
rickrambo wrote:When I run a job thru director, I see the job log. In UNIX, which directory and what file name the job log stored?

Go to the DataStage Admin and write the SQL :

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'jobName'

Once you get this JOBNO then look for the folder RT_LOGnnn on the UNIX side . Normally its under the directory where we have 'Projects' folder.

Jatinder