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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rickrambo
Participant
Posts: 21
Joined: Wed Jul 27, 2005 11:27 am

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

Post 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?
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post 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.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jatinrheen
Participant
Posts: 10
Joined: Sat Jan 01, 2005 1:32 pm

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

Post 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
Post Reply