Re: Turn on logging without archive?

Will Hartung - Master Rallyeist (villy@collinscomp.com) wrote: : Bryan Tonnet, molten keyboard in hand, chimes in with: : > : I'm sure that somewhere in the several megs of DBSPACE that are : allocated, there's a bit or two that says whether a database is logged : or not, but somehow I don't think that Informix is going to share with : us the actual location of the bit. : Most folks just run the archive to /dev/null. Takes 2 seconds. : Of course, it tends to screw your sequence up if you do incremental : backups, but that's a procedural issue. I'll tell you where it is. It's in the database tblspace. There is a good reason that an archive is required before changing the logging mode of a database, said reason left as an exercise for the reader to figure out. And the reason isn't so that Informix doesn't have to tell you where that bit is! :) ---------------------------------------------------------------------------- Bill Glidden Sr. Advanced Support Engineer E-mail: glidden@informix.com Regional Advanced Support (813) 615-0625 Informix Software, Inc. ----------------------------------------------------------------------------