Director log clear

logic · Post by **logic** » Mon Jul 25, 2005 11:42 am

Hi,
I had a job running which created a error log of more than 800000 entries.

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.

I_Server_Whale · Post by **I_Server_Whale** » Mon Jul 25, 2005 12:07 pm

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.

I_Server_Whale · Post by **I_Server_Whale** » Mon Jul 25, 2005 12:11 pm

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.

logic · Post by **logic** » Mon Jul 25, 2005 12:14 pm

Thanks naveen,
I will try deleting the Rt_LOGnn file...better than waiting for 10 mins i guess.
thanks,
Ash.

kduke · Post by **kduke** » Mon Jul 25, 2005 12:20 pm

Not a good idea. If you get to TCL then CLEAR.FILE RT_LOGnnn. That would be much better.

I_Server_Whale · Post by **I_Server_Whale** » Mon Jul 25, 2005 12:51 pm

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.

logic · Post by **logic** » Mon Jul 25, 2005 12:55 pm

ok..thanx..got it.

kollurianu · Post by **kollurianu** » Mon Jul 25, 2005 2:34 pm

by the way what is TCL ? excuse if it is a Basic question.

Thank you all.

pnchowdary · Post by **pnchowdary** » Mon Jul 25, 2005 3:33 pm

Hi Anu,

Code: Select all

TCL stands for Terminal Control Language

as Craig pointed out in one of his earlier posts.

garthmac · Post by **garthmac** » Tue Jul 26, 2005 3:29 am

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