Page 1 of 1
Possible to export DS log?
Posted: Tue Jun 03, 2008 9:33 pm
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
Posted: Tue Jun 03, 2008 9:51 pm
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.
Posted: Tue Jun 03, 2008 11:01 pm
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.
Posted: Tue Jun 03, 2008 11:17 pm
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.
Posted: Tue Jun 03, 2008 11:36 pm
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
Posted: Tue Jun 03, 2008 11:47 pm
by ag_ram
Open the Job Log, now do 'Print to file'
What you did is Job Status --> Print to file
Posted: Tue Jun 03, 2008 11:54 pm
by Brian Zhang
ag_ram wrote:Open the Job Log, now do 'Print to file'
What you did is Job Status --> Print to file
Thanks a lot!
I got it.
Brian