kbries@eu.wang.com (Kris Bries) writes:
: 	My Ingres transaction logfile is growing and I would like
: 	to know in which way I can keep this file under control
: 	or eventually clean it up.( /ingres/log/ingres_log.)

What makes you think your log file is "growing"?  It is a fixed size
file that is used as a circular buffer.  You don't need to keep it
"under control" and you shouldn't even think of playing with it
except using iistartup -init or iimakelog/iimklog.

: 	The only thing I found back is that I can resize the file
: 	with iistartup -init,so this I could do eventually.But is
: 	there no other way? 

Nope.  But I suspect you really don't want to do that anyway.

: 	Secondly,in my manuals there is described to execute following
: 	command to clean up the errlog.log file
: 	
: 	echo "" > /ingres/files/errlog.log.
: 
: 	Is this true? I found in the FAQ that this should be done
: 	STRICTLY offline.

The exact command that you use is neither here nor there.  The one you
quote will work, and so will the one in the FAQ.  As to whether it
should be done online or offline, there is some question about that.
Personally I do it only offline, but there are people whose judgement I
trust who say it is OK to do it online.  For the FAQ I erred on the
side of caution.

--Roy Hann

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William