Re: Help! Level - 0 Archive / Informix Administrator unavailable!

Bill Bertovich <billb@connect3.com> wrote in article <5n1m0f$f75@news1.ni.net>... > Informix 7.12 > Solaris ??? > > We have a small database residing on one volume for which we created a > separate blob space (for Text columns) on the same volume - pretty basic > stuff I guess. We were in the process of changing the database to use > logging (it was not using logging before). The next step was to perform a > level - 0 archive to activate the logging. > > Now the problem, > > Our Administrator had to leave unexpectedly due to an illness in the > family. > > The level - 0 archive was never performed. I cannot find our copy of the > Online Dynamic Server Administrator's Guide Vol. 1. I know what I need to > do but I have no clue as to the syntax, etc. I would like to perform the > level - 0 archive to a null device. (backups are not an issue for this > database, it is being used to test an application that is behind > schedule). > > First change the tape device to /dev/null This is most easily done using onmonitor. On entry to onmonitor ( logged in as informix ) use the right arrow key to find the archive tape menu entry and change the tape device to /dev/null. ( you can also do it be changing the onconfig file but onmonitor is easier) Then exit onmonitor and use ontape to do the archive and change the database logging at the same time ontape -s -B dbname where dbname is the database name; This will set buffered logging. Use -U in place of the -B for unbuffered logging...and if you wanted to turn logging off with ontape use -N for no logging in place of -B or -U