Re: Transaction log files in a SE database

>From: john@miso.wwa.com (pinoy_ako) >Date: 6 Sep 1995 10:34:37 -0500 >X-Informix-List-Id: <news.16765> > >Hi, > I was browsing through the manual and saw the "START DATABASE" > sql command. It says there that if you put a filename, that > filename will be the transaction log. I have two questions about > the transaction log file. > > 1. Does the transaction log file record the unload and load > statements or just the insert/delete/update statements? > (We do full unload of all tables every night) It will record the LOAD statements indirectly; they are translated into INSERT statements and the INSERT statements are logged. SELECT statements are not logged, in general; the UNLOAD statement is translated into SELECT statements. > 2. After creating a transaction log file and deciding later we > don't want it anymore, would this work the same way as if > we didn't have any transaction log file to begin with? > > START DATABASE xyz WITH LOG IN "/dev/null" No, on two counts. (1) The file must not exist when you execute the START DATABASE statement. (2) Assuming you rigged it by making a symlink from /dev/null to the file you did specify, the engine would get upset when it tried to reread the log file when it did a ROLLBACK work. To stop logging, you should use "START DATABASE xyz WITH NO LOG". Read the manual -- Informix Guide to SQL: Syntax Version 6.0. It's on the same page as the rest of the START DATABASE syntax. > We're using SE, R4GL, ver 6 on Unix. Pls. post or email. Thanks! Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>