Re: Stopping and starting transaction logging
Posted in 1998
In article <72icpm$i9a$1@news.xmission.com>, Noe, Patricia B.
<pnoe@BRFG.com> writes
>Transaction logs are backed up to DAT drive using ontape -c command
>Nightly, I do a level 0 backups to a DLT drive using the ontape -s command.
>Before I execute the level 0 backup, I kill the ontape -c session by typing
>CTRL-C in the korn shell window where ontape -c is running) I do the backup
>to the DLT, replace the DAT tape with the next day's tape and then when the
>backup is done, I type ontape -c to begin logging the transactions to tape
>again.
>
>Is this what I should be doing or am I screwing things up? I also notice
Sounds OK to me..
>that if I do not turn transaction logging back on right after I do the
>backup, the transaction logs fill up pretty quickly.
>
Correct, I normally run 1000 250K transaction logs = 240Mb..should
last a day at least..
>-Patricia Noe
>Brown, Rudnick, Freed & Gesmer
>pnoe@brfg.com
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care