Re: Logical Logs

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 ======================================================================