Backup scripts

We are using Informix 7.31.TC2 on an NT 4.0 machine and are having difficulty with the continuous logging process. Does anyone have a script that would guide us through the process? For example, if we turn continuous logging on, how do we turn it off (without sitting in front of the console) and then back up the logs so that we can then run a full instance backup? Our intent is to script this process so more than just one person can actually invoke and/or monitor the process. Thanks in advance for your help.

Hi, I guess you're currently utilizing "ontape" ? I'm not really into the Windows-World. :-) But I suggest that you utilize ON-Bar instead of ontape. It can do all the log backup and dbspace archive activities without needing interaction with someone "sitting in front of the console". And this should even work on the Windows platform ... :) Please see the manual "Backup and Restore Guide" for more information on ON-Bar. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Merrill, Do...." <DMerrill@co.lake.il.us> Sent by: forum.subscriber@iiug.org 29.01.2003 16:46 To: ids@iiug.org cc: Subject: Backup scripts [155] We are using Informix 7.31.TC2 on an NT 4.0 machine and are having difficulty with the continuous logging process. Does anyone have a script that would guide us through the process? For example, if we turn continuous logging on, how do we turn it off (without sitting in front of the console) and then back up the logs so that we can then run a full instance backup? Our intent is to script this process so more than just one person can actually invoke and/or monitor the process. Thanks in advance for your help.

What about this create 2 scripts like these: after that, use at command an the console of M$ Nt4 and activate scheduling e.g, each 10 minutes Serafin Veloso CargoSoft Consulting CargoSoft GmbH Linzer Str. 3 28359 Bremen Telefon +49 421 2020 447 Telefax +49 421 2020 189 http://www.cargosoft.de eMail: sveloso@cargosoft.de Hotline: support@cargosoft.de ******* First script: ********** set INFORMIXDIR=C:\\\\INFORMIX set INFORMIXSERVER=cargool1 set ONCONFIG=ONCONFIG.cargool1 set PATH=C:\\\\INFORMIX\\\\bin;%PATH%; set INFORMIXSQLHOSTS=\\\\\\\\FILESERVER01set DBTEMP=C:\\\\INFORMIX\\\\infxtmp set CLIENT_LOCALE=EN_US.CP1252 set DB_LOCALE=EN_US.8859-1set SERVER_LOCALE=EN_US.CP1252 set DBLANG=EN_US.CP1252 mode con codepage select=1252 set DBSPACETEMP=tmpdbs set DBMONEY=, set DBDATE=DMY4.set DELIMITER=# ontape -a < C:\\\\INFORMIX\\\\scripts\\\\enteryes.cmd ****** second script <enteryes.cmd> ****** y y y -----Ursprüngliche Nachricht----- Von: Martin Fuer.... [mailto:martinfu@de.ibm.com] Gesendet: Mittwoch, 29. Januar 2003 18:24 An: ids@iiug.org Betreff: Re: Backup scripts [158] Hi, I guess you're currently utilizing "ontape" ? I'm not really into the Windows-World. :-) But I suggest that you utilize ON-Bar instead of ontape. It can do all the log backup and dbspace archive activities without needing interaction with someone "sitting in front of the console". And this should even work on the Windows platform ... :) Please see the manual "Backup and Restore Guide" for more information on ON-Bar. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "Merrill, Do...." <DMerrill@co.lake.il.us> Sent by: forum.subscriber@iiug.org 29.01.2003 16:46 To: ids@iiug.org cc: Subject: Backup scripts [155] We are using Informix 7.31.TC2 on an NT 4.0 machine and are having difficulty with the continuous logging process. Does anyone have a script that would guide us through the process? For example, if we turn continuous logging on, how do we turn it off (without sitting in front of the console) and then back up the logs so that we can then run a full instance backup? Our intent is to script this process so more than just one person can actually invoke and/or monitor the process. Thanks in advance for your help.