Page 1 of 1

Director log clear

Posted: Mon Jul 25, 2005 11:42 am
by logic
Hi,
I had a job running which created a error log of more than 800000 entries. :lol:
Now the error is fixed ,job running fine etc. Can i use the cleanup resouces tab to just clear the log entries before the last run.
was curious to know of a way to clear the director log entries without opening the director.
when i try opening the director to view entries its hanging up..maybe because of the number of entries in the repository table for log. I am able to open and view entries for all other jobs except the one for which these entries were logged.
Thanks
Ash.

Posted: Mon Jul 25, 2005 12:07 pm
by I_Server_Whale
Are you sure its hanging? Because it will take a while to display those 800000 logs. It will take around 10 mins. Try waiting for 10 mins and see what happens.

Naveen.

Posted: Mon Jul 25, 2005 12:11 pm
by I_Server_Whale
Also, you can try deleting RT_LOGnn file for that job in the following directory:

[/code]
C:\Ascential\DataStage\Projects\dev

Code: Select all


Naveen.

Posted: Mon Jul 25, 2005 12:14 pm
by logic
Thanks naveen,
I will try deleting the Rt_LOGnn file...better than waiting for 10 mins i guess.
thanks,
Ash.

Posted: Mon Jul 25, 2005 12:20 pm
by kduke
Not a good idea. If you get to TCL then CLEAR.FILE RT_LOGnnn. That would be much better.

Posted: Mon Jul 25, 2005 12:51 pm
by I_Server_Whale
Yes! Like Duke says, clearing the RT_LOGnnn file would be better. Certainly, deleting is not a good idea. Kim, thanks for correcting me.

Naveen.

Posted: Mon Jul 25, 2005 12:55 pm
by logic
ok..thanx..got it.

Posted: Mon Jul 25, 2005 2:34 pm
by kollurianu
by the way what is TCL ? excuse if it is a Basic question.

Thank you all.

Posted: Mon Jul 25, 2005 3:33 pm
by pnchowdary
Hi Anu,

Code: Select all

TCL stands for Terminal Control Language
as Craig pointed out in one of his earlier posts.

Posted: Tue Jul 26, 2005 3:29 am
by garthmac
You can also clear the log from Director without viewing the log itself - select the job and then in the job menu, select clear log. I just had to do that for 400,000 entries