Logical Log backup

I would like to take logical log backup and I have given ontape -c L and it is taking continuous backup but I would like to run cron job and needs to complete job if any logical backup. May I use ontape -a L? I need to run once a day. If in case may be logical logs more after I have taken backup and how to run this ontap -a L Thank you very much --089e0122aefef7cd3504ec1675d3

Hi, we are using alarmprogram for such an action. That way, we do not have to worry about full logs: First, set the LTAPEDEV to a directory, make sure informix user can write to the dir. Modify the alarmprogram to call an external script (like /mylocation/backup_logs.sh). BACKUP_CMD="/mylocation/backup_logs.sh" BACKUPLOGS=Y In backup_logs.sh, you will get the correct environment (INFORMIXSERVER/INFORMIXDIR) and you can then call ontape -a: #!/bin/bash export PATH=${PATH}:${INFORMIXDIR}/binLOGNO=$1 (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} This should backup your logs in a file whenever a log file becomes full. You can analyze the /tmp/backup.out.${LOGNO} file for errors and initiate a mail to admin in case of any problem. Hope this helps. Best regards, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "medkba" <medkba@gmail.com> An: ids@iiug.org Gesendet: Dienstag, 26. November 2013 16:52:05 Betreff: Logical Log backup [32030] I would like to take logical log backup and I have given ontape -c L and it is taking continuous backup but I would like to run cron job and needs to complete job if any logical backup. May I use ontape -a L? I need to run once a day. If in case may be logical logs more after I have taken backup and how to run this ontap -a L Thank you very much --089e0122aefef7cd3504ec1675d3 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

It is not a good idea to run the logical log backups using cron. If you do not want to use cnotinuous log backup (not my favorite either), then use the ALARMPROGRAM script to do this by capturing condition code 23 (logical log completed) and lauching an ontape -a from there. The default script is configured to use onbar to do this but it is normally disabled. You will have to modify the script to use ontape instead and to enable this feature or replace the default alarmprogram script with one of your own. Note that if you use this method it is best to set LTAPEDEV to a directory or filesystem and let ontape manage the file naming. Art . Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: > I would like to take logical log backup and I have given ontape -c L and it > is taking continuous backup but I would like to run cron job and needs to > complete job if any logical backup. May I use ontape -a L? I need to run > once a day. If in case may be logical logs more after I have taken backup > and how to run this ontap -a L > > Thank you very much > > --089e0122aefef7cd3504ec1675d3 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01176b29df10ca04ec16c5d1

Art, Thank you very much Yes, I am using file system and modify on LTAPEDEV Ok, If I don't use cron job, how to logical log backup happen automatically. It is through ALARMPROGRAM script. Please correct me On Wed, Nov 27, 2013 at 12:14 AM, Art Kagel <art.kagel@gmail.com> wrote: > It is not a good idea to run the logical log backups using cron. If you do > not want to use cnotinuous log backup (not my favorite either), then use > the ALARMPROGRAM script to do this by capturing condition code 23 (logical > log completed) and lauching an ontape -a from there. The default script is > configured to use onbar to do this but it is normally disabled. You will > have to modify the script to use ontape instead and to enable this feature > or replace the default alarmprogram script with one of your own. Note that > if you use this method it is best to set LTAPEDEV to a directory or > filesystem and let ontape manage the file naming. > > Art > .. > > Art S. Kagel, Principal Consultant > > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: > > > I would like to take logical log backup and I have given ontape -c L and > it > > is taking continuous backup but I would like to run cron job and needs to > > complete job if any logical backup. May I use ontape -a L? I need to run > > once a day. If in case may be logical logs more after I have taken backup > > and how to run this ontap -a L > > > > Thank you very much > > > > --089e0122aefef7cd3504ec1675d3 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e01176b29df10ca04ec16c5d1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c265b8585b0704ec16e3c1

Just edit the alarmscript BACKUPLOGS=N BACKUP_CMD="ontape -a" And you should be good Cheers Paul > Art, > > Thank you very much > > Yes, I am using file system and modify on LTAPEDEV > > Ok, If I don't use cron job, how to logical log backup happen > automatically. It is through ALARMPROGRAM script. Please correct me > > On Wed, Nov 27, 2013 at 12:14 AM, Art Kagel <art.kagel@gmail.com> wrote: > >> It is not a good idea to run the logical log backups using cron. If you >> do >> not want to use cnotinuous log backup (not my favorite either), then use >> the ALARMPROGRAM script to do this by capturing condition code 23 >> (logical >> log completed) and lauching an ontape -a from there. The default script >> is >> configured to use onbar to do this but it is normally disabled. You will >> have to modify the script to use ontape instead and to enable this >> feature >> or replace the default alarmprogram script with one of your own. Note >> that >> if you use this method it is best to set LTAPEDEV to a directory or >> filesystem and let ontape manage the file naming. >> >> Art >> .. >> >> Art S. Kagel, Principal Consultant >> >> Advanced DataTools (www.advancedatatools.com) >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinions >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any >> other organization with which I am associated either explicitly, >> implicitly, or by inference. Neither do those opinions reflect those of >> other individuals affiliated with any entity with which I am affiliated >> nor >> those of the entities themselves. >> >> On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: >> >> > I would like to take logical log backup and I have given ontape -c L >> and >> it >> > is taking continuous backup but I would like to run cron job and needs >> to >> > complete job if any logical backup. May I use ontape -a L? I need to >> run >> > once a day. If in case may be logical logs more after I have taken >> backup >> > and how to run this ontap -a L >> > >> > Thank you very much >> > >> > --089e0122aefef7cd3504ec1675d3 >> > >> > >> > >> > >> >> > ******************************************************************************* >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> > >> >> --089e01176b29df10ca04ec16c5d1 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11c265b8585b0704ec16e3c1 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

Yes. When a logical log fills and the engine changes to the next log it issues an alarm class 23 to the ALARMPROGRAM script. If you look in the script, $INFORMIXDIR/etc/log_full.sh, for event code 23 you will see the code that currently would execute onbar through the variable BACKUP_CMD. Just modify that variable to "ontape -a -l" and enable the backups as someone else detailed. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 11:22 AM, medkba <medkba@gmail.com> wrote: > Art, > > Thank you very much > > Yes, I am using file system and modify on LTAPEDEV > > Ok, If I don't use cron job, how to logical log backup happen > automatically. It is through ALARMPROGRAM script. Please correct me > > On Wed, Nov 27, 2013 at 12:14 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > It is not a good idea to run the logical log backups using cron. If you > do > > not want to use cnotinuous log backup (not my favorite either), then use > > the ALARMPROGRAM script to do this by capturing condition code 23 > (logical > > log completed) and lauching an ontape -a from there. The default script > is > > configured to use onbar to do this but it is normally disabled. You will > > have to modify the script to use ontape instead and to enable this > feature > > or replace the default alarmprogram script with one of your own. Note > that > > if you use this method it is best to set LTAPEDEV to a directory or > > filesystem and let ontape manage the file naming. > > > > Art > > .. > > > > Art S. Kagel, Principal Consultant > > > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: > > > > > I would like to take logical log backup and I have given ontape -c L > and > > it > > > is taking continuous backup but I would like to run cron job and needs > to > > > complete job if any logical backup. May I use ontape -a L? I need to > run > > > once a day. If in case may be logical logs more after I have taken > backup > > > and how to run this ontap -a L > > > > > > Thank you very much > > > > > > --089e0122aefef7cd3504ec1675d3 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e01176b29df10ca04ec16c5d1 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c265b8585b0704ec16e3c1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c683acdf9e304ec16fed4

Thank you very much Paul Could you share any link or doc about alarmscript On Wed, Nov 27, 2013 at 12:27 AM, Paul Watson <paul@oninit.com> wrote: > Just edit the alarmscript > > BACKUPLOGS=N > BACKUP_CMD="ontape -a" > > And you should be good > > Cheers > Paul > > > Art, > > > > Thank you very much > > > > Yes, I am using file system and modify on LTAPEDEV > > > > Ok, If I don't use cron job, how to logical log backup happen > > automatically. It is through ALARMPROGRAM script. Please correct me > > > > On Wed, Nov 27, 2013 at 12:14 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > >> It is not a good idea to run the logical log backups using cron. If you > >> do > >> not want to use cnotinuous log backup (not my favorite either), then use > >> the ALARMPROGRAM script to do this by capturing condition code 23 > >> (logical > >> log completed) and lauching an ontape -a from there. The default script > >> is > >> configured to use onbar to do this but it is normally disabled. You will > >> have to modify the script to use ontape instead and to enable this > >> feature > >> or replace the default alarmprogram script with one of your own. Note > >> that > >> if you use this method it is best to set LTAPEDEV to a directory or > >> filesystem and let ontape manage the file naming. > >> > >> Art > >> .. > >> > >> Art S. Kagel, Principal Consultant > >> > >> Advanced DataTools (www.advancedatatools.com) > >> Blog: http://informix-myview.blogspot.com/ > >> > >> Disclaimer: Please keep in mind that my own opinions are my own opinions > >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > >> other organization with which I am associated either explicitly, > >> implicitly, or by inference. Neither do those opinions reflect those of > >> other individuals affiliated with any entity with which I am affiliated > >> nor > >> those of the entities themselves. > >> > >> On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: > >> > >> > I would like to take logical log backup and I have given ontape -c L > >> and > >> it > >> > is taking continuous backup but I would like to run cron job and needs > >> to > >> > complete job if any logical backup. May I use ontape -a L? I need to > >> run > >> > once a day. If in case may be logical logs more after I have taken > >> backup > >> > and how to run this ontap -a L > >> > > >> > Thank you very much > >> > > >> > --089e0122aefef7cd3504ec1675d3 > >> > > >> > > >> > > >> > > >> > >> > > > > ******************************************************************************* > >> > Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > >> > > >> > >> --089e01176b29df10ca04ec16c5d1 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > --001a11c265b8585b0704ec16e3c1 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > Paul Watson > Tel: +1 913-674-0360 > Mob: +1 913-387-7529 > Web: www.oninit.com > > www.advancedatatools.com > > Failure is not as frightening as regret. > If you want to improve, be content to be thought foolish and stupid. > What this country needs are more unemployed politicians > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c26b1222adcc04ec1701ed

Thank you very much I need to clarify below if i don't use alarmprogrm, Am I able to run shell script once a day? Is it fine or still I need to set alaramprogram for this On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann <marcus.haarmann@midoco.de > wrote: > Hi, > > we are using alarmprogram for such an action. That way, we do not have to > worry about full logs: > First, set the LTAPEDEV to a directory, make sure informix user can write > to > the dir. > > Modify the alarmprogram to call an external script (like > /mylocation/backup_logs.sh). > BACKUP_CMD="/mylocation/backup_logs.sh" > BACKUPLOGS=Y > > In backup_logs.sh, you will get the correct environment > (INFORMIXSERVER/INFORMIXDIR) > and you can then call ontape -a: > #!/bin/bash > export PATH=${PATH}:${INFORMIXDIR}/bin> LOGNO=$1 > (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} > > This should backup your logs in a file whenever a log file becomes full. > You can analyze the /tmp/backup.out.${LOGNO} file for errors and initiate > a mail to admin in case of any problem. > > Hope this helps. > > Best regards, > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "medkba" <medkba@gmail.com> > An: ids@iiug.org > Gesendet: Dienstag, 26. November 2013 16:52:05 > Betreff: Logical Log backup [32030] > > I would like to take logical log backup and I have given ontape -c L and it > is taking continuous backup but I would like to run cron job and needs to > complete job if any logical backup. May I use ontape -a L? I need to run > once a day. If in case may be logical logs more after I have taken backup > and how to run this ontap -a L > > Thank you very much > > --089e0122aefef7cd3504ec1675d3 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e012279a2090fe204ec16b3b7

Yep, but probably not 'best practice' Cheers Paul > Thank you very much > > I need to clarify below > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is > it > fine or still I need to set alaramprogram for this > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann > <marcus.haarmann@midoco.de >> wrote: > >> Hi, >> >> we are using alarmprogram for such an action. That way, we do not have >> to >> worry about full logs: >> First, set the LTAPEDEV to a directory, make sure informix user can >> write >> to >> the dir. >> >> Modify the alarmprogram to call an external script (like >> /mylocation/backup_logs.sh). >> BACKUP_CMD="/mylocation/backup_logs.sh" >> BACKUPLOGS=Y >> >> In backup_logs.sh, you will get the correct environment >> (INFORMIXSERVER/INFORMIXDIR) >> and you can then call ontape -a: >> #!/bin/bash >> export PATH=${PATH}:${INFORMIXDIR}/bin>> LOGNO=$1 >> (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} >> >> This should backup your logs in a file whenever a log file becomes full. >> You can analyze the /tmp/backup.out.${LOGNO} file for errors and >> initiate >> a mail to admin in case of any problem. >> >> Hope this helps. >> >> Best regards, >> >> Marcus Haarmann >> >> ----- Ursprüngliche Mail ----- >> >> Von: "medkba" <medkba@gmail.com> >> An: ids@iiug.org >> Gesendet: Dienstag, 26. November 2013 16:52:05 >> Betreff: Logical Log backup [32030] >> >> I would like to take logical log backup and I have given ontape -c L and >> it >> is taking continuous backup but I would like to run cron job and needs >> to >> complete job if any logical backup. May I use ontape -a L? I need to run >> once a day. If in case may be logical logs more after I have taken >> backup >> and how to run this ontap -a L >> >> Thank you very much >> >> --089e0122aefef7cd3504ec1675d3 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --089e012279a2090fe204ec16b3b7 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

If you only back up your logical logs once a day, then how will you recover if the server crashes hard? If it does that shortly before the script would have run, you will lose a full day's transactions when you restore your last full archive and cannot roll forward the logical logs to the last few minutes before the crash. Can your company afford that kind of data loss? Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote: > Thank you very much > > I need to clarify below > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is it > fine or still I need to set alaramprogram for this > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann < > marcus.haarmann@midoco.de > > wrote: > > > Hi, > > > > we are using alarmprogram for such an action. That way, we do not have to > > worry about full logs: > > First, set the LTAPEDEV to a directory, make sure informix user can write > > to > > the dir. > > > > Modify the alarmprogram to call an external script (like > > /mylocation/backup_logs.sh). > > BACKUP_CMD="/mylocation/backup_logs.sh" > > BACKUPLOGS=Y > > > > In backup_logs.sh, you will get the correct environment > > (INFORMIXSERVER/INFORMIXDIR) > > and you can then call ontape -a: > > #!/bin/bash > > export PATH=${PATH}:${INFORMIXDIR}/bin> > LOGNO=$1 > > (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} > > > > This should backup your logs in a file whenever a log file becomes full. > > You can analyze the /tmp/backup.out.${LOGNO} file for errors and initiate > > a mail to admin in case of any problem. > > > > Hope this helps. > > > > Best regards, > > > > Marcus Haarmann > > > > ----- Ursprüngliche Mail ----- > > > > Von: "medkba" <medkba@gmail.com> > > An: ids@iiug.org > > Gesendet: Dienstag, 26. November 2013 16:52:05 > > Betreff: Logical Log backup [32030] > > > > I would like to take logical log backup and I have given ontape -c L and > it > > is taking continuous backup but I would like to run cron job and needs to > > complete job if any logical backup. May I use ontape -a L? I need to run > > once a day. If in case may be logical logs more after I have taken backup > > and how to run this ontap -a L > > > > Thank you very much > > > > --089e0122aefef7cd3504ec1675d3 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e012279a2090fe204ec16b3b7 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135e9d6c6005e04ec172597

https://pic.dhe.ibm.com/infocenter/informix/v121/topic/com.ibm.adref.doc/ids_adr _0669.htm > Thank you very much Paul > > Could you share any link or doc about alarmscript > > On Wed, Nov 27, 2013 at 12:27 AM, Paul Watson <paul@oninit.com> wrote: > >> Just edit the alarmscript >> >> BACKUPLOGS=N >> BACKUP_CMD="ontape -a" >> >> And you should be good >> >> Cheers >> Paul >> >> > Art, >> > >> > Thank you very much >> > >> > Yes, I am using file system and modify on LTAPEDEV >> > >> > Ok, If I don't use cron job, how to logical log backup happen >> > automatically. It is through ALARMPROGRAM script. Please correct me >> > >> > On Wed, Nov 27, 2013 at 12:14 AM, Art Kagel <art.kagel@gmail.com> >> wrote: >> > >> >> It is not a good idea to run the logical log backups using cron. If >> you >> >> do >> >> not want to use cnotinuous log backup (not my favorite either), then >> use >> >> the ALARMPROGRAM script to do this by capturing condition code 23 >> >> (logical >> >> log completed) and lauching an ontape -a from there. The default >> script >> >> is >> >> configured to use onbar to do this but it is normally disabled. You >> will >> >> have to modify the script to use ontape instead and to enable this >> >> feature >> >> or replace the default alarmprogram script with one of your own. Note >> >> that >> >> if you use this method it is best to set LTAPEDEV to a directory or >> >> filesystem and let ontape manage the file naming. >> >> >> >> Art >> >> .. >> >> >> >> Art S. Kagel, Principal Consultant >> >> >> >> Advanced DataTools (www.advancedatatools.com) >> >> Blog: http://informix-myview.blogspot.com/ >> >> >> >> Disclaimer: Please keep in mind that my own opinions are my own >> opinions >> >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor >> any >> >> other organization with which I am associated either explicitly, >> >> implicitly, or by inference. Neither do those opinions reflect those >> of >> >> other individuals affiliated with any entity with which I am >> affiliated >> >> nor >> >> those of the entities themselves. >> >> >> >> On Tue, Nov 26, 2013 at 10:52 AM, medkba <medkba@gmail.com> wrote: >> >> >> >> > I would like to take logical log backup and I have given ontape -c >> L >> >> and >> >> it >> >> > is taking continuous backup but I would like to run cron job and >> needs >> >> to >> >> > complete job if any logical backup. May I use ontape -a L? I need >> to >> >> run >> >> > once a day. If in case may be logical logs more after I have taken >> >> backup >> >> > and how to run this ontap -a L >> >> > >> >> > Thank you very much >> >> > >> >> > --089e0122aefef7cd3504ec1675d3 >> >> > >> >> > >> >> > >> >> > >> >> >> >> >> > >> >> > ******************************************************************************* >> >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > >> >> > >> >> >> >> --089e01176b29df10ca04ec16c5d1 >> >> >> >> >> >> >> >> >> > >> >> > ******************************************************************************* >> >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> >> > >> > --001a11c265b8585b0704ec16e3c1 >> > >> > >> > >> >> > ******************************************************************************* >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> >> -- >> Paul Watson >> Tel: +1 913-674-0360 >> Mob: +1 913-387-7529 >> Web: www.oninit.com >> >> www.advancedatatools.com >> >> Failure is not as frightening as regret. >> If you want to improve, be content to be thought foolish and stupid. >> What this country needs are more unemployed politicians >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11c26b1222adcc04ec1701ed > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

HI, What version of IDS are you using ? 1/ If you are using one of the latest versions: 11 and up, it is best to use the alarmprogram.sh shell script provided with the product. It is located in $INFORMIXDIR/etc You need to modify it a bit because it has been prepared for onbar: make the following changes to the alarmprogram.sh file: *BACKUPLOGS=Y ... BACKUP_CMD="ontape -a -d"* 2/ Change the value of the ALARMPROGRAM in you onconfig file to: $INFORMIXDIR/etc/alarmprogram.sh If you have on of the latest versions of IDS, you can use: *onmode -wf ALARMPROGRAM=$INFORMIXDIR/etc/alarmprogram.sh* This command will not only activate the alarmprogram.sh while the engine is running but will update your $ONCONFIG file as well without having to stop the engine or change the file $ONCONFIG by hand. Hope that this helps. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 26/11/13 17:37, medkba a écrit : > Thank you very much > > I need to clarify below > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is it > fine or still I need to set alaramprogram for this > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann<marcus.haarmann@midoco.de >> wrote: >> Hi, >> >> we are using alarmprogram for such an action. That way, we do not have to >> worry about full logs: >> First, set the LTAPEDEV to a directory, make sure informix user can write >> to >> the dir. >> >> Modify the alarmprogram to call an external script (like >> /mylocation/backup_logs.sh). >> BACKUP_CMD="/mylocation/backup_logs.sh" >> BACKUPLOGS=Y >> >> In backup_logs.sh, you will get the correct environment >> (INFORMIXSERVER/INFORMIXDIR) >> and you can then call ontape -a: >> #!/bin/bash >> export PATH=${PATH}:${INFORMIXDIR}/bin>> LOGNO=$1 >> (ontape -a -d 2>&1)> /tmp/backup.out.${LOGNO} >> >> This should backup your logs in a file whenever a log file becomes full. >> You can analyze the /tmp/backup.out.${LOGNO} file for errors and initiate >> a mail to admin in case of any problem. >> >> Hope this helps. >> >> Best regards, >> >> Marcus Haarmann >> >> ----- Ursprüngliche Mail ----- >> >> Von: "medkba"<medkba@gmail.com> >> An: ids@iiug.org >> Gesendet: Dienstag, 26. November 2013 16:52:05 >> Betreff: Logical Log backup [32030] >> >> I would like to take logical log backup and I have given ontape -c L and it >> is taking continuous backup but I would like to run cron job and needs to >> complete job if any logical backup. May I use ontape -a L? I need to run >> once a day. If in case may be logical logs more after I have taken backup >> and how to run this ontap -a L >> >> Thank you very much >> >> --089e0122aefef7cd3504ec1675d3 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --089e012279a2090fe204ec16b3b7 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Art, Sorry, I didn't update this part. I am taking daily L0 backup currently. We need to recover point in time that's why need to enable logical log backup as well Thank you very much On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel <art.kagel@gmail.com> wrote: > If you only back up your logical logs once a day, then how will you recover > if the server crashes hard? If it does that shortly before the script > would have run, you will lose a full day's transactions when you restore > your last full archive and cannot roll forward the logical logs to the last > few minutes before the crash. Can your company afford that kind of data > loss? > > Art > > Art S. Kagel, Principal Consultant > > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote: > > > Thank you very much > > > > I need to clarify below > > > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is > it > > fine or still I need to set alaramprogram for this > > > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann < > > marcus.haarmann@midoco.de > > > wrote: > > > > > Hi, > > > > > > we are using alarmprogram for such an action. That way, we do not have > to > > > worry about full logs: > > > First, set the LTAPEDEV to a directory, make sure informix user can > write > > > to > > > the dir. > > > > > > Modify the alarmprogram to call an external script (like > > > /mylocation/backup_logs.sh). > > > BACKUP_CMD="/mylocation/backup_logs.sh" > > > BACKUPLOGS=Y > > > > > > In backup_logs.sh, you will get the correct environment > > > (INFORMIXSERVER/INFORMIXDIR) > > > and you can then call ontape -a: > > > #!/bin/bash > > > export PATH=${PATH}:${INFORMIXDIR}/bin> > > LOGNO=$1 > > > (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} > > > > > > This should backup your logs in a file whenever a log file becomes > full. > > > You can analyze the /tmp/backup.out.${LOGNO} file for errors and > initiate > > > a mail to admin in case of any problem. > > > > > > Hope this helps. > > > > > > Best regards, > > > > > > Marcus Haarmann > > > > > > ----- Ursprüngliche Mail ----- > > > > > > Von: "medkba" <medkba@gmail.com> > > > An: ids@iiug.org > > > Gesendet: Dienstag, 26. November 2013 16:52:05 > > > Betreff: Logical Log backup [32030] > > > > > > I would like to take logical log backup and I have given ontape -c L > and > > it > > > is taking continuous backup but I would like to run cron job and needs > to > > > complete job if any logical backup. May I use ontape -a L? I need to > run > > > once a day. If in case may be logical logs more after I have taken > backup > > > and how to run this ontap -a L > > > > > > Thank you very much > > > > > > --089e0122aefef7cd3504ec1675d3 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e012279a2090fe204ec16b3b7 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1135e9d6c6005e04ec172597 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e012279a2e0711f04ec1e3dae

Right and you need to be making that log backup every time a log file is completed. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 8:09 PM, medkba <medkba@gmail.com> wrote: > Art, Sorry, I didn't update this part. I am taking daily L0 backup > currently. We need to recover point in time that's why need to enable > logical log backup as well > > Thank you very much > > On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > If you only back up your logical logs once a day, then how will you > recover > > if the server crashes hard? If it does that shortly before the script > > would have run, you will lose a full day's transactions when you restore > > your last full archive and cannot roll forward the logical logs to the > last > > few minutes before the crash. Can your company afford that kind of data > > loss? > > > > Art > > > > Art S. Kagel, Principal Consultant > > > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote: > > > > > Thank you very much > > > > > > I need to clarify below > > > > > > if i don't use alarmprogrm, Am I able to run shell script once a day? > Is > > it > > > fine or still I need to set alaramprogram for this > > > > > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann < > > > marcus.haarmann@midoco.de > > > > wrote: > > > > > > > Hi, > > > > > > > > we are using alarmprogram for such an action. That way, we do not > have > > to > > > > worry about full logs: > > > > First, set the LTAPEDEV to a directory, make sure informix user can > > write > > > > to > > > > the dir. > > > > > > > > Modify the alarmprogram to call an external script (like > > > > /mylocation/backup_logs.sh). > > > > BACKUP_CMD="/mylocation/backup_logs.sh" > > > > BACKUPLOGS=Y > > > > > > > > In backup_logs.sh, you will get the correct environment > > > > (INFORMIXSERVER/INFORMIXDIR) > > > > and you can then call ontape -a: > > > > #!/bin/bash > > > > export PATH=${PATH}:${INFORMIXDIR}/bin> > > > LOGNO=$1 > > > > (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} > > > > > > > > This should backup your logs in a file whenever a log file becomes > > full. > > > > You can analyze the /tmp/backup.out.${LOGNO} file for errors and > > initiate > > > > a mail to admin in case of any problem. > > > > > > > > Hope this helps. > > > > > > > > Best regards, > > > > > > > > Marcus Haarmann > > > > > > > > ----- Ursprüngliche Mail ----- > > > > > > > > Von: "medkba" <medkba@gmail.com> > > > > An: ids@iiug.org > > > > Gesendet: Dienstag, 26. November 2013 16:52:05 > > > > Betreff: Logical Log backup [32030] > > > > > > > > I would like to take logical log backup and I have given ontape -c L > > and > > > it > > > > is taking continuous backup but I would like to run cron job and > needs > > to > > > > complete job if any logical backup. May I use ontape -a L? I need to > > run > > > > once a day. If in case may be logical logs more after I have taken > > backup > > > > and how to run this ontap -a L > > > > > > > > Thank you very much > > > > > > > > --089e0122aefef7cd3504ec1675d3 > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e012279a2090fe204ec16b3b7 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a1135e9d6c6005e04ec172597 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e012279a2e0711f04ec1e3dae > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134640cdb23e804ec1eca62

I have modified following entry and how do i test after changes make the following changes to the alarmprogram.sh file: *BACKUPLOGS=Y .... BACKUP_CMD="ontape -a -d"* 2/ Change the value of the ALARMPROGRAM in you onconfig file to: $INFORMIXDIR/etc/alarmprogram.sh On Wed, Nov 27, 2013 at 6:55 AM, Khaled Bentebal < khaled.bentebal@consult-ix.fr> wrote: > HI, > > What version of IDS are you using ? > > 1/ If you are using one of the latest versions: 11 and up, it is best to > use the alarmprogram.sh shell script provided with the product. > > It is located in $INFORMIXDIR/etc > > You need to modify it a bit because it has been prepared for onbar: > > make the following changes to the alarmprogram.sh file: > *BACKUPLOGS=Y > .... > BACKUP_CMD="ontape -a -d"* > > 2/ Change the value of the ALARMPROGRAM in you onconfig file to: > $INFORMIXDIR/etc/alarmprogram.sh > > If you have on of the latest versions of IDS, you can use: > > *onmode -wf ALARMPROGRAM=$INFORMIXDIR/etc/alarmprogram.sh* > > This command will not only activate the alarmprogram.sh while the engine > is running but will update your $ONCONFIG file as well without having to > stop the engine or change the file $ONCONFIG by hand. > > Hope that this helps. > > Cordialement, Regards, > > Khaled Bentebal > Directeur Général - ConsultiX > Président UGIF - User Group Informix France > IIUG - Board of Directors > Tél: 33 (0) 1 39 12 18 00 > Fax: 33 (0) 1 39 12 18 18 > Mobile: 33 (0) 6 07 78 41 97 > Email: khaled.bentebal@consult-ix.fr > Site Web: www.consult-ix.fr > > Le 26/11/13 17:37, medkba a écrit : > > Thank you very much > > > > I need to clarify below > > > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is > it > > fine or still I need to set alaramprogram for this > > > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann< > marcus.haarmann@midoco.de > >> wrote: > >> Hi, > >> > >> we are using alarmprogram for such an action. That way, we do not have > to > >> worry about full logs: > >> First, set the LTAPEDEV to a directory, make sure informix user can > write > >> to > >> the dir. > >> > >> Modify the alarmprogram to call an external script (like > >> /mylocation/backup_logs.sh). > >> BACKUP_CMD="/mylocation/backup_logs.sh" > >> BACKUPLOGS=Y > >> > >> In backup_logs.sh, you will get the correct environment > >> (INFORMIXSERVER/INFORMIXDIR) > >> and you can then call ontape -a: > >> #!/bin/bash > >> export PATH=${PATH}:${INFORMIXDIR}/bin> >> LOGNO=$1 > >> (ontape -a -d 2>&1)> /tmp/backup.out.${LOGNO} > >> > >> This should backup your logs in a file whenever a log file becomes full. > >> You can analyze the /tmp/backup.out.${LOGNO} file for errors and > initiate > >> a mail to admin in case of any problem. > >> > >> Hope this helps. > >> > >> Best regards, > >> > >> Marcus Haarmann > >> > >> ----- Ursprüngliche Mail ----- > >> > >> Von: "medkba"<medkba@gmail.com> > >> An: ids@iiug.org > >> Gesendet: Dienstag, 26. November 2013 16:52:05 > >> Betreff: Logical Log backup [32030] > >> > >> I would like to take logical log backup and I have given ontape -c L > and it > >> is taking continuous backup but I would like to run cron job and needs > to > >> complete job if any logical backup. May I use ontape -a L? I need to run > >> once a day. If in case may be logical logs more after I have taken > backup > >> and how to run this ontap -a L > >> > >> Thank you very much > >> > >> --089e0122aefef7cd3504ec1675d3 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > --089e012279a2090fe204ec16b3b7 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2672a64e68904ec20ec01

Hi, use onmode -l to force a new log. It will trigger the alarm program and backup the log in case you have setup everything correctly. Best regards, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "medkba" <medkba@gmail.com> An: ids@iiug.org Gesendet: Mittwoch, 27. November 2013 05:21:04 Betreff: Re: Logical Log backup [32057] I have modified following entry and how do i test after changes make the following changes to the alarmprogram.sh file: *BACKUPLOGS=Y ..... BACKUP_CMD="ontape -a -d"* 2/ Change the value of the ALARMPROGRAM in you onconfig file to: $INFORMIXDIR/etc/alarmprogram.sh On Wed, Nov 27, 2013 at 6:55 AM, Khaled Bentebal < khaled.bentebal@consult-ix.fr> wrote: > HI, > > What version of IDS are you using ? > > 1/ If you are using one of the latest versions: 11 and up, it is best to > use the alarmprogram.sh shell script provided with the product. > > It is located in $INFORMIXDIR/etc > > You need to modify it a bit because it has been prepared for onbar: > > make the following changes to the alarmprogram.sh file: > *BACKUPLOGS=Y > .... > BACKUP_CMD="ontape -a -d"* > > 2/ Change the value of the ALARMPROGRAM in you onconfig file to: > $INFORMIXDIR/etc/alarmprogram.sh > > If you have on of the latest versions of IDS, you can use: > > *onmode -wf ALARMPROGRAM=$INFORMIXDIR/etc/alarmprogram.sh* > > This command will not only activate the alarmprogram.sh while the engine > is running but will update your $ONCONFIG file as well without having to > stop the engine or change the file $ONCONFIG by hand. > > Hope that this helps. > > Cordialement, Regards, > > Khaled Bentebal > Directeur Général - ConsultiX > Président UGIF - User Group Informix France > IIUG - Board of Directors > Tél: 33 (0) 1 39 12 18 00 > Fax: 33 (0) 1 39 12 18 18 > Mobile: 33 (0) 6 07 78 41 97 > Email: khaled.bentebal@consult-ix.fr > Site Web: www.consult-ix.fr > > Le 26/11/13 17:37, medkba a écrit : > > Thank you very much > > > > I need to clarify below > > > > if i don't use alarmprogrm, Am I able to run shell script once a day? Is > it > > fine or still I need to set alaramprogram for this > > > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann< > marcus.haarmann@midoco.de > >> wrote: > >> Hi, > >> > >> we are using alarmprogram for such an action. That way, we do not have > to > >> worry about full logs: > >> First, set the LTAPEDEV to a directory, make sure informix user can > write > >> to > >> the dir. > >> > >> Modify the alarmprogram to call an external script (like > >> /mylocation/backup_logs.sh). > >> BACKUP_CMD="/mylocation/backup_logs.sh" > >> BACKUPLOGS=Y > >> > >> In backup_logs.sh, you will get the correct environment > >> (INFORMIXSERVER/INFORMIXDIR) > >> and you can then call ontape -a: > >> #!/bin/bash > >> export PATH=${PATH}:${INFORMIXDIR}/bin> >> LOGNO=$1 > >> (ontape -a -d 2>&1)> /tmp/backup.out.${LOGNO} > >> > >> This should backup your logs in a file whenever a log file becomes full. > >> You can analyze the /tmp/backup.out.${LOGNO} file for errors and > initiate > >> a mail to admin in case of any problem. > >> > >> Hope this helps. > >> > >> Best regards, > >> > >> Marcus Haarmann > >> > >> ----- Ursprüngliche Mail ----- > >> > >> Von: "medkba"<medkba@gmail.com> > >> An: ids@iiug.org > >> Gesendet: Dienstag, 26. November 2013 16:52:05 > >> Betreff: Logical Log backup [32030] > >> > >> I would like to take logical log backup and I have given ontape -c L > and it > >> is taking continuous backup but I would like to run cron job and needs > to > >> complete job if any logical backup. May I use ontape -a L? I need to run > >> once a day. If in case may be logical logs more after I have taken > backup > >> and how to run this ontap -a L > >> > >> Thank you very much > >> > >> --089e0122aefef7cd3504ec1675d3 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > --089e012279a2090fe204ec16b3b7 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2672a64e68904ec20ec01 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Either you wait until the currently used log is full or you force it to go to the next log by issuing the following command: onmode -l Then you check using : onstat -lYou should see the following flags for all of the logs except for the current one: U-B-- Make sure that your LTAPEDEV et LTAPESIZE have been set in order for your backup to perform the save of the logs where you want. Khaled Bentebal de mon portable Le 27 nov. 2013 à 05:21, "medkba" <medkba@gmail.com> a écrit : > I have modified following entry and how do i test after changes > > make the following changes to the alarmprogram.sh file: > *BACKUPLOGS=Y > ..... > BACKUP_CMD="ontape -a -d"* > > 2/ Change the value of the ALARMPROGRAM in you onconfig file to: > $INFORMIXDIR/etc/alarmprogram.sh > > On Wed, Nov 27, 2013 at 6:55 AM, Khaled Bentebal < > khaled.bentebal@consult-ix.fr> wrote: > >> HI, >> >> What version of IDS are you using ? >> >> 1/ If you are using one of the latest versions: 11 and up, it is best to >> use the alarmprogram.sh shell script provided with the product. >> >> It is located in $INFORMIXDIR/etc >> >> You need to modify it a bit because it has been prepared for onbar: >> >> make the following changes to the alarmprogram.sh file: >> *BACKUPLOGS=Y >> .... >> BACKUP_CMD="ontape -a -d"* >> >> 2/ Change the value of the ALARMPROGRAM in you onconfig file to: >> $INFORMIXDIR/etc/alarmprogram.sh >> >> If you have on of the latest versions of IDS, you can use: >> >> *onmode -wf ALARMPROGRAM=$INFORMIXDIR/etc/alarmprogram.sh* >> >> This command will not only activate the alarmprogram.sh while the engine >> is running but will update your $ONCONFIG file as well without having to >> stop the engine or change the file $ONCONFIG by hand. >> >> Hope that this helps. >> >> Cordialement, Regards, >> >> Khaled Bentebal >> Directeur Général - ConsultiX >> Président UGIF - User Group Informix France >> IIUG - Board of Directors >> Tél: 33 (0) 1 39 12 18 00 >> Fax: 33 (0) 1 39 12 18 18 >> Mobile: 33 (0) 6 07 78 41 97 >> Email: khaled.bentebal@consult-ix.fr >> Site Web: www.consult-ix.fr >> >> Le 26/11/13 17:37, medkba a écrit : >>> Thank you very much >>> >>> I need to clarify below >>> >>> if i don't use alarmprogrm, Am I able to run shell script once a day? Is >> it >>> fine or still I need to set alaramprogram for this >>> >>> On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann< >> marcus.haarmann@midoco.de >>>> wrote: >>>> Hi, >>>> >>>> we are using alarmprogram for such an action. That way, we do not have >> to >>>> worry about full logs: >>>> First, set the LTAPEDEV to a directory, make sure informix user can >> write >>>> to >>>> the dir. >>>> >>>> Modify the alarmprogram to call an external script (like >>>> /mylocation/backup_logs.sh). >>>> BACKUP_CMD="/mylocation/backup_logs.sh" >>>> BACKUPLOGS=Y >>>> >>>> In backup_logs.sh, you will get the correct environment >>>> (INFORMIXSERVER/INFORMIXDIR) >>>> and you can then call ontape -a: >>>> #!/bin/bash >>>> export PATH=${PATH}:${INFORMIXDIR}/bin>>>> LOGNO=$1 >>>> (ontape -a -d 2>&1)> /tmp/backup.out.${LOGNO} >>>> >>>> This should backup your logs in a file whenever a log file becomes full. >>>> You can analyze the /tmp/backup.out.${LOGNO} file for errors and >> initiate >>>> a mail to admin in case of any problem. >>>> >>>> Hope this helps. >>>> >>>> Best regards, >>>> >>>> Marcus Haarmann >>>> >>>> ----- Ursprüngliche Mail ----- >>>> >>>> Von: "medkba"<medkba@gmail.com> >>>> An: ids@iiug.org >>>> Gesendet: Dienstag, 26. November 2013 16:52:05 >>>> Betreff: Logical Log backup [32030] >>>> >>>> I would like to take logical log backup and I have given ontape -c L >> and it >>>> is taking continuous backup but I would like to run cron job and needs >> to >>>> complete job if any logical backup. May I use ontape -a L? I need to run >>>> once a day. If in case may be logical logs more after I have taken >> backup >>>> and how to run this ontap -a L >>>> >>>> Thank you very much >>>> >>>> --089e0122aefef7cd3504ec1675d3 > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> --089e012279a2090fe204ec16b3b7 > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2672a64e68904ec20ec01 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

If you need point in time, you need to use onbar instead of ontape. Ontape can only recover full logs. In that case you need to set up a lot more things to use onbar and do you have a third party tool such as TSM or something else. What version of IDS are you using and what tool are you using to perform your backups? Khaled Bentebal de mon portable Le 27 nov. 2013 à 02:09, "medkba" <medkba@gmail.com> a écrit : > Art, Sorry, I didn't update this part. I am taking daily L0 backup > currently. We need to recover point in time that's why need to enable > logical log backup as well > > Thank you very much > > On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel <art.kagel@gmail.com> wrote: > >> If you only back up your logical logs once a day, then how will you recover >> if the server crashes hard? If it does that shortly before the script >> would have run, you will lose a full day's transactions when you restore >> your last full archive and cannot roll forward the logical logs to the last >> few minutes before the crash. Can your company afford that kind of data >> loss? >> >> Art >> >> Art S. Kagel, Principal Consultant >> >> Advanced DataTools (www.advancedatatools.com) >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinions >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any >> other organization with which I am associated either explicitly, >> implicitly, or by inference. Neither do those opinions reflect those of >> other individuals affiliated with any entity with which I am affiliated nor >> those of the entities themselves. >> >> On Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote: >> >>> Thank you very much >>> >>> I need to clarify below >>> >>> if i don't use alarmprogrm, Am I able to run shell script once a day? Is >> it >>> fine or still I need to set alaramprogram for this >>> >>> On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann < >>> marcus.haarmann@midoco.de >>>> wrote: >>> >>>> Hi, >>>> >>>> we are using alarmprogram for such an action. That way, we do not have >> to >>>> worry about full logs: >>>> First, set the LTAPEDEV to a directory, make sure informix user can >> write >>>> to >>>> the dir. >>>> >>>> Modify the alarmprogram to call an external script (like >>>> /mylocation/backup_logs.sh). >>>> BACKUP_CMD="/mylocation/backup_logs.sh" >>>> BACKUPLOGS=Y >>>> >>>> In backup_logs.sh, you will get the correct environment >>>> (INFORMIXSERVER/INFORMIXDIR) >>>> and you can then call ontape -a: >>>> #!/bin/bash >>>> export PATH=${PATH}:${INFORMIXDIR}/bin>>>> LOGNO=$1 >>>> (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} >>>> >>>> This should backup your logs in a file whenever a log file becomes >> full. >>>> You can analyze the /tmp/backup.out.${LOGNO} file for errors and >> initiate >>>> a mail to admin in case of any problem. >>>> >>>> Hope this helps. >>>> >>>> Best regards, >>>> >>>> Marcus Haarmann >>>> >>>> ----- Ursprüngliche Mail ----- >>>> >>>> Von: "medkba" <medkba@gmail.com> >>>> An: ids@iiug.org >>>> Gesendet: Dienstag, 26. November 2013 16:52:05 >>>> Betreff: Logical Log backup [32030] >>>> >>>> I would like to take logical log backup and I have given ontape -c L >> and >>> it >>>> is taking continuous backup but I would like to run cron job and needs >> to >>>> complete job if any logical backup. May I use ontape -a L? I need to >> run >>>> once a day. If in case may be logical logs more after I have taken >> backup >>>> and how to run this ontap -a L >>>> >>>> Thank you very much >>>> >>>> --089e0122aefef7cd3504ec1675d3 > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> --089e012279a2090fe204ec16b3b7 > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> --001a1135e9d6c6005e04ec172597 > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e012279a2e0711f04ec1e3dae > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

IDS 11.50 FC9. I may be use ontape due to we don't have TSM On Wed, Nov 27, 2013 at 3:52 PM, Khaled BENTEBAL < khaled.bentebal@consult-ix.fr> wrote: > If you need point in time, you need to use onbar instead of ontape. > Ontape can only recover full logs. > > In that case you need to set up a lot more things to use onbar and do you > have > a third party tool such as TSM or something else. > > What version of IDS are you using and what tool are you using to perform > your > backups? > > Khaled Bentebal de mon portable > > Le 27 nov. 2013 à 02:09, "medkba" <medkba@gmail.com> a écrit : > > > Art, Sorry, I didn't update this part. I am taking daily L0 backup > > currently. We need to recover point in time that's why need to enable > > logical log backup as well > > > > Thank you very much > > > > On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > >> If you only back up your logical logs once a day, then how will you > recover > >> if the server crashes hard? If it does that shortly before the script > >> would have run, you will lose a full day's transactions when you restore > >> your last full archive and cannot roll forward the logical logs to the > last > >> few minutes before the crash. Can your company afford that kind of data > >> loss? > >> > >> Art > >> > >> Art S. Kagel, Principal Consultant > >> > >> Advanced DataTools (www.advancedatatools.com) > >> Blog: http://informix-myview.blogspot.com/ > >> > >> Disclaimer: Please keep in mind that my own opinions are my own opinions > >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > >> other organization with which I am associated either explicitly, > >> implicitly, or by inference. Neither do those opinions reflect those of > >> other individuals affiliated with any entity with which I am affiliated > nor > >> those of the entities themselves. > >> > >> On Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote: > >> > >>> Thank you very much > >>> > >>> I need to clarify below > >>> > >>> if i don't use alarmprogrm, Am I able to run shell script once a day? > Is > >> it > >>> fine or still I need to set alaramprogram for this > >>> > >>> On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann < > >>> marcus.haarmann@midoco.de > >>>> wrote: > >>> > >>>> Hi, > >>>> > >>>> we are using alarmprogram for such an action. That way, we do not have > >> to > >>>> worry about full logs: > >>>> First, set the LTAPEDEV to a directory, make sure informix user can > >> write > >>>> to > >>>> the dir. > >>>> > >>>> Modify the alarmprogram to call an external script (like > >>>> /mylocation/backup_logs.sh). > >>>> BACKUP_CMD="/mylocation/backup_logs.sh" > >>>> BACKUPLOGS=Y > >>>> > >>>> In backup_logs.sh, you will get the correct environment > >>>> (INFORMIXSERVER/INFORMIXDIR) > >>>> and you can then call ontape -a: > >>>> #!/bin/bash > >>>> export PATH=${PATH}:${INFORMIXDIR}/bin> >>>> LOGNO=$1 > >>>> (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO} > >>>> > >>>> This should backup your logs in a file whenever a log file becomes > >> full. > >>>> You can analyze the /tmp/backup.out.${LOGNO} file for errors and > >> initiate > >>>> a mail to admin in case of any problem. > >>>> > >>>> Hope this helps. > >>>> > >>>> Best regards, > >>>> > >>>> Marcus Haarmann > >>>> > >>>> ----- Ursprüngliche Mail ----- > >>>> > >>>> Von: "medkba" <medkba@gmail.com> > >>>> An: ids@iiug.org > >>>> Gesendet: Dienstag, 26. November 2013 16:52:05 > >>>> Betreff: Logical Log backup [32030] > >>>> > >>>> I would like to take logical log backup and I have given ontape -c L > >> and > >>> it > >>>> is taking continuous backup but I would like to run cron job and needs > >> to > >>>> complete job if any logical backup. May I use ontape -a L? I need to > >> run > >>>> once a day. If in case may be logical logs more after I have taken > >> backup > >>>> and how to run this ontap -a L > >>>> > >>>> Thank you very much > >>>> > >>>> --089e0122aefef7cd3504ec1675d3 > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> --089e012279a2090fe204ec16b3b7 > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> --001a1135e9d6c6005e04ec172597 > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --089e012279a2e0711f04ec1e3dae > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2f7742de83e04ec2497a4

In that case you can use Informix Storage Manager(ISM). &nbsp;I believe it still comes bundled with IDS.Read more about it here -&nbsp;http://www-01.ibm.com/support/docview.wss?uid=swg21405145 Lloyd From: "medkba" &lt;medkba@gmail.com&gt; Sent: Wed, 27 Nov 2013 14:14:12 To: ids@iiug.org Subject: Re: Logical Log backup [32061] IDS 11.50 FC9. I may be use ontape due to we don't have TSM On Wed, Nov 27, 2013 at 3:52 PM, Khaled BENTEBAL &lt; khaled.bentebal@consult-ix.fr&gt; wrote: &gt; If you need point in time, you need to use onbar instead of ontape. &gt; Ontape can only recover full logs. &gt; &gt; In that case you need to set up a lot more things to use onbar and do you &gt; have &gt; a third party tool such as TSM or something else. &gt; &gt; What version of IDS are you using and what tool are you using to perform &gt; your &gt; backups? &gt; &gt; Khaled Bentebal de mon portable &gt; &gt; Le 27 nov. 2013 মbsp;02:09, "medkba" &lt;medkba@gmail.com&gt; a 飲it :&nbsp; &gt; &gt; &gt; Art, Sorry, I didn't update this part. I am taking daily L0 backup &gt; &gt; currently. We need to recover point in time that's why need to enable &gt; &gt; logical log backup as well &gt; &gt; &gt; &gt; Thank you very much &gt; &gt; &gt; &gt; On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel &lt;art.kagel@gmail.com&gt; wrote: &gt; &gt; &gt; &gt;&gt; If you only back up your logical logs once a day, then how will you &gt; recover &gt; &gt;&gt; if the server crashes hard? If it does that shortly before the script &gt; &gt;&gt; would have run, you will lose a full day's transactions when you restore &gt; &gt;&gt; your last full archive and cannot roll forward the logical logs to the &gt; last &gt; &gt;&gt; few minutes before the crash. Can your company afford that kind of data &gt; &gt;&gt; loss? &gt; &gt;&gt; &gt; &gt;&gt; Art &gt; &gt;&gt; &gt; &gt;&gt; Art S. Kagel, Principal Consultant &gt; &gt;&gt; &gt; &gt;&gt; Advanced DataTools (www.advancedatatools.com) &gt; &gt;&gt; Blog: http://informix-myview.blogspot.com/ &gt; &gt;&gt; &gt; &gt;&gt; Disclaimer: Please keep in mind that my own opinions are my own opinions &gt; &gt;&gt; and do not reflect on my employer, Advanced DataTools, the IIUG, nor any &gt; &gt;&gt; other organization with which I am associated either explicitly, &gt; &gt;&gt; implicitly, or by inference. Neither do those opinions reflect those of &gt; &gt;&gt; other individuals affiliated with any entity with which I am affiliated &gt; nor &gt; &gt;&gt; those of the entities themselves. &gt; &gt;&gt; &gt; &gt;&gt; On Tue, Nov 26, 2013 at 11:37 AM, medkba &lt;medkba@gmail.com&gt; wrote: &gt; &gt;&gt; &gt; &gt;&gt;&gt; Thank you very much &gt; &gt;&gt;&gt; &gt; &gt;&gt;&gt; I need to clarify below &gt; &gt;&gt;&gt; &gt; &gt;&gt;&gt; if i don't use alarmprogrm, Am I able to run shell script once a day? &gt; Is &gt; &gt;&gt; it &gt; &gt;&gt;&gt; fine or still I need to set alaramprogram for this &gt; &gt;&gt;&gt; &gt; &gt;&gt;&gt; On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann &lt; &gt; &gt;&gt;&gt; marcus.haarmann@midoco.de &gt; &gt;&gt;&gt;&gt; wrote: &gt; &gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Hi, &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; we are using alarmprogram for such an action. That way, we do not have &gt; &gt;&gt; to &gt; &gt;&gt;&gt;&gt; worry about full logs: &gt; &gt;&gt;&gt;&gt; First, set the LTAPEDEV to a directory, make sure informix user can &gt; &gt;&gt; write &gt; &gt;&gt;&gt;&gt; to &gt; &gt;&gt;&gt;&gt; the dir. &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Modify the alarmprogram to call an external script (like &gt; &gt;&gt;&gt;&gt; /mylocation/backup_logs.sh). &gt; &gt;&gt;&gt;&gt; BACKUP_CMD="/mylocation/backup_logs.sh" &gt; &gt;&gt;&gt;&gt; BACKUPLOGS=Y &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; In backup_logs.sh, you will get the correct environment &gt; &gt;&gt;&gt;&gt; (INFORMIXSERVER/INFORMIXDIR) &gt; &gt;&gt;&gt;&gt; and you can then call ontape -a: &gt; &gt;&gt;&gt;&gt; #!/bin/bash &gt; &gt;&gt;&gt;&gt; export PATH=${PATH}:${INFORMIXDIR}/bin &gt; &gt;&gt;&gt;&gt; LOGNO=$1 &gt; &gt;&gt;&gt;&gt; (ontape -a -d 2&gt;&amp;1) &gt; /tmp/backup.out.${LOGNO} &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; This should backup your logs in a file whenever a log file becomes &gt; &gt;&gt; full. &gt; &gt;&gt;&gt;&gt; You can analyze the /tmp/backup.out.${LOGNO} file for errors and &gt; &gt;&gt; initiate &gt; &gt;&gt;&gt;&gt; a mail to admin in case of any problem. &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Hope this helps. &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Best regards, &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Marcus Haarmann &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; ----- Urspr쮧liche Mail ----- &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Von: "medkba" &lt;medkba@gmail.com&gt; &gt; &gt;&gt;&gt;&gt; An: ids@iiug.org &gt; &gt;&gt;&gt;&gt; Gesendet: Dienstag, 26. November 2013 16:52:05 &gt; &gt;&gt;&gt;&gt; Betreff: Logical Log backup [32030] &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; I would like to take logical log backup and I have given ontape -c L &gt; &gt;&gt; and &gt; &gt;&gt;&gt; it &gt; &gt;&gt;&gt;&gt; is taking continuous backup but I would like to run cron job and needs &gt; &gt;&gt; to &gt; &gt;&gt;&gt;&gt; complete job if any logical backup. May I use ontape -a L? I need to &gt; &gt;&gt; run &gt; &gt;&gt;&gt;&gt; once a day. If in case may be logical logs more after I have taken &gt; &gt;&gt; backup &gt; &gt;&gt;&gt;&gt; and how to run this ontap -a L &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; Thank you very much &gt; &gt;&gt;&gt;&gt; &gt; &gt;&gt;&gt;&gt; --089e0122aefef7cd3504ec1675d3 &gt; &gt; &gt; &gt; ******************************************************************************* &gt; &gt;&gt;&gt;&gt; Forum Note: Use "Reply" to post a response in the discussion forum. &gt; &gt; &gt; &gt; ******************************************************************************* &gt; &gt;&gt;&gt;&gt; Forum Note: Use "Reply" to post a response in the discussion forum. &gt; &gt;&gt;&gt; &gt; &gt;&gt;&gt; --089e012279a2090fe204ec16b3b7 &gt; &gt; &gt; &gt; *******************************************************************************@@

Just force a logical log change with "onmode -l". You should see a message about backing up the log in the message log immediately after the message announcing the log change. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 26, 2013 at 11:21 PM, medkba <medkba@gmail.com> wrote: > I have modified following entry and how do i test after changes > > make the following changes to the alarmprogram.sh file: > *BACKUPLOGS=Y > ..... > BACKUP_CMD="ontape -a -d"* > > 2/ Change the value of the ALARMPROGRAM in you onconfig file to: > $INFORMIXDIR/etc/alarmprogram.sh > > On Wed, Nov 27, 2013 at 6:55 AM, Khaled Bentebal < > khaled.bentebal@consult-ix.fr> wrote: > > > HI, > > > > What version of IDS are you using ? > > > > 1/ If you are using one of the latest versions: 11 and up, it is best to > > use the alarmprogram.sh shell script provided with the product. > > > > It is located in $INFORMIXDIR/etc > > > > You need to modify it a bit because it has been prepared for onbar: > > > > make the following changes to the alarmprogram.sh file: > > *BACKUPLOGS=Y > > .... > > BACKUP_CMD="ontape -a -d"* > > > > 2/ Change the value of the ALARMPROGRAM in you onconfig file to: > > $INFORMIXDIR/etc/alarmprogram.sh > > > > If you have on of the latest versions of IDS, you can use: > > > > *onmode -wf ALARMPROGRAM=$INFORMIXDIR/etc/alarmprogram.sh* > > > > This command will not only activate the alarmprogram.sh while the engine > > is running but will update your $ONCONFIG file as well without having to > > stop the engine or change the file $ONCONFIG by hand. > > > > Hope that this helps. > > > > Cordialement, Regards, > > > > Khaled Bentebal > > Directeur Général - ConsultiX > > Président UGIF - User Group Informix France > > IIUG - Board of Directors > > Tél: 33 (0) 1 39 12 18 00 > > Fax: 33 (0) 1 39 12 18 18 > > Mobile: 33 (0) 6 07 78 41 97 > > Email: khaled.bentebal@consult-ix.fr > > Site Web: www.consult-ix.fr > > > > Le 26/11/13 17:37, medkba a écrit : > > > Thank you very much > > > > > > I need to clarify below > > > > > > if i don't use alarmprogrm, Am I able to run shell script once a day? > Is > > it > > > fine or still I need to set alaramprogram for this > > > > > > On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann< > > marcus.haarmann@midoco.de > > >> wrote: > > >> Hi, > > >> > > >> we are using alarmprogram for such an action. That way, we do not have > > to > > >> worry about full logs: > > >> First, set the LTAPEDEV to a directory, make sure informix user can > > write > > >> to > > >> the dir. > > >> > > >> Modify the alarmprogram to call an external script (like > > >> /mylocation/backup_logs.sh). > > >> BACKUP_CMD="/mylocation/backup_logs.sh" > > >> BACKUPLOGS=Y > > >> > > >> In backup_logs.sh, you will get the correct environment > > >> (INFORMIXSERVER/INFORMIXDIR) > > >> and you can then call ontape -a: > > >> #!/bin/bash > > >> export PATH=${PATH}:${INFORMIXDIR}/bin> > >> LOGNO=$1 > > >> (ontape -a -d 2>&1)> /tmp/backup.out.${LOGNO} > > >> > > >> This should backup your logs in a file whenever a log file becomes > full. > > >> You can analyze the /tmp/backup.out.${LOGNO} file for errors and > > initiate > > >> a mail to admin in case of any problem. > > >> > > >> Hope this helps. > > >> > > >> Best regards, > > >> > > >> Marcus Haarmann > > >> > > >> ----- Ursprüngliche Mail ----- > > >> > > >> Von: "medkba"<medkba@gmail.com> > > >> An: ids@iiug.org > > >> Gesendet: Dienstag, 26. November 2013 16:52:05 > > >> Betreff: Logical Log backup [32030] > > >> > > >> I would like to take logical log backup and I have given ontape -c L > > and it > > >> is taking continuous backup but I would like to run cron job and needs > > to > > >> complete job if any logical backup. May I use ontape -a L? I need to > run > > >> once a day. If in case may be logical logs more after I have taken > > backup > > >> and how to run this ontap -a L > > >> > > >> Thank you very much > > >> > > >> --089e0122aefef7cd3504ec1675d3 > > >> > > >> > > >> > > >> > > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > >> > > >> > > >> > > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > >> > > > --089e012279a2090fe204ec16b3b7 > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c2672a64e68904ec20ec01 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134ba568e126704ec26da61

I have to thank all the people for their lights on this topic, i have the same need and now i know what to do