Re: Turn on logging without archive?
Posted in 1996
Bryan Tonnet, molten keyboard in hand, chimes in with: > > A had occasion the other day to want to turn on logging on an On-line 5.0X > database for a short time. I simply wanted to test some code using > transactions, and only neeeded the logs for a short time. > > Knowing that the procedure was to create an archive first, I duly did same > and then started the logging....but I got to wondering, during the hour of > the archive, whether there is a simply change I could make to the system > catalogues to short circuit the process. 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. Enjoy! Will