RE: Log files full

Even though you have a non logging database, some operations still must be logged. For example, table creations are logged. So maybe when you reinitialize and recreate your database your table creations are being logged causing your (I'm guessing you have only a few logical logs since you are not using logging) logical logs to fill up. I beleive if you set LTAPEDEV to /dev/null Informix will automatically mark your logs as backed up when they are full, this will allow you to write over your existing logs. Andrew -----Original Message----- From: Tony Pich [SMTP:apich@viviance.com] Sent: Friday, August 11, 2000 10:49 AM To: informix-list@iiug.org Subject: Log files full 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