Re: Question concerning log files

In article <6fdpr4$3cf$1@news.xmission.com>, Nick Nobbe <nnob@loc.gov> writes > >Thanks, > >I guess I should have made it clear I was talking about SE. > >Agreed, Online has various interesting ways of dealing with it. Here's the >paradox: How to do a humungous load or re-index one table while others are >using the database in loggin mode? Looks like you have to manage the >logsize, as in the online /dev/null scenario with logging continuous or in >SE by nulling the log every so often. > The ONLY way do this under SE is to do delete from systables where tabtype = "L"; This is from Informix UK Tech Support. It is not OFFICIALLY supported but does work. THERE IS NO OFFICALLY SUPPORTED WAY..!!!.. Remember to do isql <database name> close database; start database <database name> with log in "<full path to log file>" to re-enable logging afterwards. >Yours, > Nick >> >********************* >Nick Nobbe >NLS/BPH >Library of Congress >nnob@loc.gov -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care