Re: Logical Logs

Tim, do you know the magic flag? I have been using dbimport on OWS 7.20 (old name) and have NOT been able to turn off logging. I think I read that this is a "feature" of Informix. I believe dbload has an option to disable logging, but dbimport is much easier for loading many tables at once. I would like to disable logging on my dbimport because when I load my history data (7 years) my logs have to be hugh to handle the import... Steve -- Steven L Cooper Manager, Systems Engineering --------------------------------------- The views expressed here are mine and you can't have them...unless you agree! Tim Schaefer <tschaefe@mindspring.com> wrote in article <349D0D78.D7BA7BC1@mindspring.com>... > Art S. Kagel wrote: > > > > PRAVEEN MOHANAN wrote: > > > > > > Hi users, > > > > > > The env i am using is Informix OWS 7.20. The database i am > > > using dosen't have logs. So in my esql/c programs if i user BEGIN WORK > > > it gives me an error. Can anybody tell how to create log for existing > > > database or if i export the database how to import it into a databse > > > with logs. > > > > For unbuffered logging: > > ontape -s -L0 -U database1 database2 ... databaseN> > > > For buffered logging: > > ontape -s -L0 -B db1 db2 ... dbN> > > > For ANSI style logging: > > ontape -s -L0 -A db1 db2 ... dbN> > > > Art S. Kagel > > I was cruisin' through c.d.i., and saw this. I noticed on NT you > need to use a space after the -L before the zero thusly: > > ontape -s -L 0 -B db1 db2 ... dbN> > There is also the ondblog command to consider as well, at least on NT, > and for the 7.x engine. Just a little teeny tiny extra thought on > this one. It's also a good idea to leave logging off when doing dbimports > to avoid long transactions on big table loads, plus it runs faster. > > Tim > > -- > Tim Schaefer \\\\|// > tschaefe@mindspring.com 6 6 > -------------------------------oOOo---( )---o00o---------------------- > http://www.inxutil.com http://www.informix.com > http://www.iiug.org news://comp.databases.informix > mailto:majordomo@iiug.org no subject body: subscribe linux-informix > ====================================================================== >