Path: utzoo!censor!geac!torsqnt!lethe!yunexus!ists!helios.physics.utoronto.ca!news-server.csri.toronto.edu!cs.utexas.edu!usc!sdd.hp.com!hplabs!pyramid!infmx!aland
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases
Subject: Re: Informix - how to drop log-file
Message-ID: <1991Feb4.090518.15372@informix.com>
Date: 4 Feb 91 09:05:18 GMT
References: <1991Feb1.193923.11298@abalon.se>
Sender: news@informix.com (Usenet News)
Organization: INFORMIX MCS   ("I've fallen, and I can't get up!")
Lines: 36

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

The oceans dry up, the ground shakes, and the Sun explodes.   [-:

>logging after that?  I haven't dared to try it out,,,

If you are using the SE engine, this is the only safe way to turn off
logging.  The creating DBA would do the following in SQL:

   delete from systables where tabname = "syslog";

Just be *sure* that you want to do this before you do it.  After
that row is deleted from systables and you have closed the database,
you can "rm" the log file.  As for integrity, however, you're on your
own.

For the OnLine engine, log mode can be changed between no logging,
buffered logging, and unbuffered logging.  Use the Databases option
of the Logical-Logs menu.  Note that to go from no logging to logging
(any variety), you can only do this immediately after performing an
archive in the same tbmonitor session.

--
Alan Denney  #  aland@informix.com  #  {pyramid|uunet}!infmx!aland

 "Now they'll have this "Chunnel" thing, parallel tunnels running 
  between England and France.  Let's see.  The English drive on the
  left side, and the French drive on the right side.   Hmmmmm.
  That's going to be one *busy* lane!"               - John Mendoza