Possible to export DS log?

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
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

Possible to export DS log?

Post by Brian Zhang »

Hi All,

Is that possible to export DataStage job log to plain text flie from Director?
Or may I locate the log file on DataStage server?

Thanks in advance.

Regards
Brian
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Open the Project menu in Director and choose the Print option.

When the Print dialog opens, check the "Print to file" check box as well as options that determine how much of the log is to be dumped.

Click OK and the common dialog for choosing a file name opens, in which you specify the name of the file to receive the output.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

Post by Brian Zhang »

ray.wurlod wrote:Open the Project menu in Director and choose the Print option.

When the Print dialog opens, check the "Print to file" check box as well as options that determine how much of the log is to be dumped ...
Thanks, Ray.
I could just see part of your comments on it anyway.

The way you mentioned above to get log info in file is not the one I expected. I want a file including the DS job running information like what we see in Log window in Director.
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

The part information that you just got(from ray.wurlod's post) is more than enough to answer your first question.

The answer to your second question is:

The Log file in the server is RT_LOGnnn(nnn --> Job Number). It is not a text file so that you can directly view the Job Log instead a dynamic hashed file(Type 30) and which will be present in the DataStage Project directory.

The Deletion of this file RT_LOGnnn directly will cause the corresponding Job useless until you do 'Create Copy' on the job after that.
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

Post by Brian Zhang »

ag_ram wrote:The part information that you just got(from ray.wurlod's post) is more than enough to answer your first question.

The answer to your second question is:

The Log file in the server is RT_LOGnnn(nnn --> Job Number). It is not a text file so that you can directly view the Job Log instead a dynamic hashed file(Type 30) and which will be present in the DataStage Project directory.

The Deletion of this file RT_LOGnnn directly will cause the corresponding Job useless until you do 'Create Copy' on the job after that.
Hi Ram,

Thanks for your quick reply.

The Print only provide job summary information as follows,
DataStage Report - Detail Status of jobs:
Produced on: 6/4/2008 1:31:03 PM
Project: Asahi_dev
Host system: AsahiBrewery
Items: 1 - 31
Sorted on: Job name

Item #: 1
Job name: DR0SAET_1000_01_SV
Status: Not compiled
Started:
On date:
Last ran:
On date:
Elapsed time:
Description: (No description)

Item #: 2
Job name: DR0SAET_1001_01_SV
Status: Finished (see log)
Started: 01:27 PM
On date: 6/3/2008
Last ran: 01:27 PM
On date: 6/3/2008
Elapsed time: 00:00:01
Description:
But what I expected is the detail information in a DS job, just like the information listed in Log windows in Director.

Thanks
Brian
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

Open the Job Log, now do 'Print to file'

What you did is Job Status --> Print to file
Brian Zhang
Participant
Posts: 39
Joined: Tue Jun 03, 2008 12:13 am
Location: Melbourne

Post by Brian Zhang »

ag_ram wrote:Open the Job Log, now do 'Print to file'

What you did is Job Status --> Print to file
:wink: Thanks a lot!
I got it.

Brian
Post Reply