Page 1 of 1

How to ftp the log from command prompt

Posted: Fri Aug 03, 2007 7:06 am
by somu_june
Hi,


I have a problem in seeing job log from Director, I am having so many warnings in job due to Foreign Key failures , is there a way can I get the log through ftp . Where can I find the log files in the server





Thanks,
SomaRaju

Posted: Fri Aug 03, 2007 7:23 am
by chulett
The 'logs' are hashed files in the job's Project. So, no - you won't be able to access them outside of DataStage. And if you have so many errors that the log either becomes unwieldy or perhaps even corrupted you'll need to take special measures.

I'd suggest you turn off the automatic 'Refresh' option in the Director and then be sure you have the 'Filter' option enabled so that only a small number of the actual records will be shown. Then, View the log. Patience is the key as it will take some time.

If you don't actually need to see the warnings, then determine the job's internal number and 'truncate' it from the Administrator:

Code: Select all

CLEAR.FILE RT_LOGxxxx
Where xxxx if the job number. This will also remove any 'Auto Purge' settings you had for this job so you'd need to re-establish them afterwards.