Re: Log files full

It sounds like you have a long-running transaction - what are your LTXHWM and LTXEHWM params in your onconfig set to? Logging is used by DDL commands among a few other types of administration tasks, so even a non-logging database will do logging, just not as much. I'd suggest changing your LTAPEDEV param to /dev/null if you don't care about those internal changes. -FPL >>> "Tony Pich" <apich@viviance.com> 08/11/00 09:48AM >>> Hi: I'm a newbie in Informix, so this question might be very obvious to most of you. I'm creating a database with no log in a tablespace other than root. This tablespace has a log file associated. Anyways, after creating the database and creating/dropping/etc.. some objects, I get 15:29:30 Logical Log Files are Full -- Backup is Needed and my database goes 'offline'. I don't know how to solve this, so the only way for me is to reinstall the database. Why are my logical log files getting full?? I told my database not to use logging!!!! What can I do to recover my database? It might also be that the root tablespace is out of logging space. Can anyone give me some advice here? Thanks a milion. -- Regards, Tony