Re: Question concerning log files

David Barnish wrote: > > Hello all, > I wonder if someone can help me. I am supporting a product using > Informix-SE version 5.06.UC1 running on SCO Unix. The logging is enabled > and it is getting in the way. We don't need any logging but I don't want > to have to recreate the database without logging. > My question is this, is it safe to copy /dev/null to the logging > file in order to clear it out on a periodic basis? Example: "cp > /dev/null /u/stuff/stuff.log". > I would prefer an email to me at dbarnish@onel.com, but I'll check > this group as well. > Thanks, > > --------------------------------------------------------------- > > Name: vcard.vcf > Part 1.2 Type: text/x-vcard > Encoding: 7bit > Description: Card for David Barnish I use logging on SE and refresh the log file before backup. It works like this: 1. create a database with logging 2. copy the (empty) log file with permissions, owner etc to log.proto 3. write a script to operate before backup which does the following: 4. rename current log to a logfile with a date in the name (unique) 5. create a new logfile with appropriate ownership and permissions from the (empty) prototype 6. remove old log files, age depends on your backup schedule If you remove logging you also lose transactions. That's a big price to pay, in my opinion, for a small gain in speed. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/