Re: INFORMIX ON-LINE (v5.0) asyncronous backups

>From: artur@morgaine.fct.unl.pt (Artur Romao) >Subject: INFORMIX ON-LINE (v5.0) asyncronous backups >Date: Thu, 30 Dec 1993 11:43:15 GMT > >Hi, > >I would like to know if anyone could help me in the following question: > >Is it possible to make on INFORMIX ON-LINE version 5.0, asyncronous >backups, i.e., create a batch-job on crontab (or something similar). >The objective is to avoid the necessity of backups during the daily >period of work. > >I've already asked a INFORMIX specialist who said that it wasn't possible. > >Please reply by e-mail, since I don't have Usenet access and I'm using >a friend's account (and he doesn't read this group). > >Thanks in advance. >_________________________________________________ >| Pedro Neves | >| Info-excelencia, Sist. Informacao | >| R. Jose da Purificacao Chaves, 9, 1.B | >| 1500 Lisboa Portugal | >| (351) 01 774 2551 | >| pn@info-ex.pt | >------------------------------------------------- Pedro, What I am going to suggest is not supported. Do not come crying to Informix or me if something goes wrong. You can run tbtape in the background provided you feed it with the data it needs, and provided that your archive will fit on one tape volume. Typically, this means you run a (Bourne/Korn) shell script such as: -------------------cut------------------- tbtape <<! >tbtape.log 2>&1 0 ! mail -s "Output from TBTAPE: `date`" root informix pn@info-ex.pt < tbtape.log rm -f tbtape.log -------------------cut------------------- The 0 says do a level 0 archive. The blank line says the tape is in the drive. Heaven help you if this is not the case. Ditto if you find the archive needing more than one tape volume, or if a media error occurs, or if almost anything goes wrong. This is why running archives in background is unsupported and unsupportable. Version 6 comes with an automatic facility called ON-Archive to handle these sorts of issues, and it does handle errors and problems during backups, at least to some extent. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>