Re: Transaction log under SE v5.

In article <3610DD86.65B8@bayer.co.uk>, Peter Lancashire <Peter.Lancashi re.PL1@bayer.co.uk> writes >David Williams wrote: >> >> In article <360FC512.B2337540@connix.com>, Tom Hamilton >> <thami@connix.com> writes >> >What can I get away with with the transaction log under a ANSI >> >database. The log I have is near the max >> >file size for the OS (solaris) can I just close the database, delete the >> >log (or archive it) and open another log. >> >How should I be managing these log files? Any help would be >> >appreciated. >> > >> >tom hamilton >> > >> >> Get everyone out of the database >> Bcheck + Backup the database >> cat /dev/null > logfile >> >> Easy! >> -- >> David Williams > >To answer the "how should I" question: I backup every day and change the >log file immediately before backup. A cron job kicks in overnight, >throws off any users who can't sleep and does the work. Old log files >are renamed with a unique name (includes the date) and a new log file >(with the correct permissions) created. Log files older than a week are >thrown away. > >Shouldn't Informix be providing a shell script to manage this for SE >administrators as it seems to crop up quite often? If someone can provide one I'll add it as an appendix to the FAQ... -- 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