Re: Transaction log under SE v5.

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? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/