Re: Can't backup logical logs to /dev/null -Reply

This message has started appearing in Informix recent versions. My memory is faulty but it seems to have something to do with changes to the config. Informix will not allow backups to /dev/null until a proper archive has been done. This would seem to be a worthy feature. I have worked around it on my test systems by backing up logs to /tmp/nullfile, a file that is symbolically linked to /dev/null. Informix allows this. rgds Peter Tashkoff <tashkop@zespri.co.nz> Zespri International Limited This posting may not be used by any party to vilify another. Standard disclaimers apply. >>> Richard Johnson <richj@hiwaay.net> 19/June/1997 12:27pm >>> On Wed, 18 Jun 1997 15:54:49 GMT, jason@cimedia.com (Jason Bodnar) wrote: >Went through all the logical log backup recommendations and alot said >to do automatic/continuous backup to /dev/null. Logs were full at >first so I added another logical log. Now when I try it I get a >message saying I can't backup logs to /dev/null: > >Taz:/home/archive/informix/etc$ ontape -a > >Performing automatic backup of logical logs. > >Please mount tape 1 on /dev/null and press Return to continue ... > >Logbackup failed - Log backup to device /dev/null not allowed > > >Please label this tape as number 1 in the log tape sequence. > >This tape contains the following logical logs: > 1 (partial) > >Program over. >-- >Jason C. Bodnar >jason@cimedia.com >Internet Programmer >Cox Interactive Media What version of Informix are you running? With version 7.X and the logical log backup device set to /dev/null means that the log automatically goes to a backed up status upon filling. As a side note, if you are not interested in using the logical logs for recovery, then why not turn off transaction logging in your database. This will GREATLY reduce writes to the logs, and will require less frequent backups. Richard