RE: Log files full

In development, perhaps, archiving isn't THAT critical; assuming you're not doing much data input while testing, and can afford to lose what you do enter. On the production side, logging is a MUST (unless you happen to work for a firm that can throw away money when you lose x amount of time due to a disk failing, etc.) I'm limited on disk space, so unfortunately I HAVE to run archive logs to tape all day long; when one of the operations crew has an operator "headspace and timing alignment error" and forgets to turn on logging, I have the same problem. Fix: (duh) Dump logs to tape, bring db back online, and march on. Joe Robinson, SFC System Administrator USPFO for Oregon, Oregon Army National Guard Email: robinsonj@or-arng.ngb.army.mil <mailto:robinsonj@or-arng.ngb.army.mil> Phone: (503) 945-3776 DSN 355-3776 FAX: (503) 945-3959 DSN 355-3959 -----Original Message----- From: Tony Pich [mailto:apich@viviance.com] Sent: Friday, August 11, 2000 8: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