Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!abalon!clindh
From: clindh@abalon.se (Christer Lindh)
Newsgroups: comp.databases
Subject: Informix - how to drop log-file
Message-ID: <1991Feb1.193923.11298@abalon.se>
Date: 1 Feb 91 19:39:23 GMT
Organization: Abalon AB, Stockholm, Sweden
Lines: 13

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,,,
-- 
::         clindh@abalon.se          ::    o/          ::                ::
::   Abalon AB, Stockholm, Sweden    ::   /@           ::    BitBucket   ::
::                                   ::   <|\          ::      lives!    ::
::      *All disclaimers apply*      ::    |   climb!  ::                ::