Re: Logical Log Backups.

Assuming you're using OnLine 7.x, you can customize the alarm program to send out an e-mail or page when the logical logs get close to full. A message automatically is generated by the engine when all but one of the log files are full. If you have an alarm program, it will process this message. Check out the chapter on alarm programs in the documentation. For the record, if you make it a point to monitor using onstat -l on a frequent basis, you'll see whether or not the logs are backing up (whether or not the status goes to "B"). If you check it, and find that they're not, then the tape is probably full. The alarm won't kick in until well after the tape fills, because it won't fire until almost all of the logs have filled without being backed up. Tim J Hope wrote in message <73e9ov$d7q$1@news.xmission.com>... > > >--openmail-part-01a70b72-00000001 >Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" >Content-Disposition: inline; filename="BDY.TXT" >Content-Transfer-Encoding: 7bit > >Hi, > What happens is the database engine hangs until the tape gets >changed. We have had that happen a number of times where we forgot to >change the log tape in time. After changing the tape the logs will >write to the new tape and the engine will free itself. > Another option is to change the tape device to /dev/null. This >will cause the log files to be lost though. If you take this option >you should do a level 0 immediately following. > >Regards, >Tim Hope > >Why are there flotation devices under plane seats instead of parachutes? > >-----Original Message----- >From: tim [SMTP:tim@blackbird.net] >Sent: Monday, November 23, 1998 6:11 PM >To: informix-list >Cc: tim >Subject: Logical Log Backups. > >I'm having trouble finding a solution to a rather simple question. >If you are backing up logical logs to tape, what happens when the tape >fills up? Obviously you would not want to write over transactions. Do >you need to guess how fast the tape will fill up and swap them out once >in a while? If a archive is made I understand that the logical logs >before the archive are not necessary to restore, but what happens if the >tape fills up before an archive occurs? > >Thanks for any advice, > >Tim > >--openmail-part-01a70b72-00000001-- >