Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!trac2000!gls
From: gls@trac2000.ueci.com (Gary Smith)
Newsgroups: comp.databases
Subject: Re: Informix - how to drop log-file
Message-ID: <973@trac2000.ueci.com>
Date: 2 Feb 91 13:32:54 GMT
References: <1991Feb1.193923.11298@abalon.se>
Organization: UE&C - Catalytic in Philadelphia, PA
Lines: 21

In article <1991Feb1.193923.11298@abalon.se>, clindh@abalon.se (Christer Lindh) writes:
> Once a database has been created/started with a transaction log I
> can't see any way to drop that transaction file again and run the DB
> without transaction logging.  You can start the database with another
> log-file but there is no "START DATABASE WITHOUT LOG" for example.
> 
> I found an entry in systables ('syslog') that keeps the name of the 
> log-file. What'll happen if I remove this row, will the DB run without
> logging after that?  I haven't dared to try it out,,,

There is also an entry is the systables table where systables.tabtype = 'L'.
You should remove that entry also.  However, I could not understand why you 
would want to stop the logging.  If there is a problem with disk space, then
when you archive the database for a backup, then just cat /dev/null to the
transaction log file to clear it out.

-- 
Gary L. Smith @ UE&C-Catalytic   |||  Reply at:  
                                 |||      UUCP:  ..!uunet!trac2000!gls
Spock - ST IV: "What does it     |||  INTERNET:  gls@trac2000.ueci.com
 mean 'Exact change only' ?"     |||