Database backup Archive 0 and Logical Log backup

Hi All, Currently, we are doing database backup Level 0 and Logical Log backup on to tape drives. Is it possible to change to NAS disk instead of tape drives. We are using Informix 11.50 on HP-UX machine. If yes, please let me know the statement or script for this Thank you very much Regards Baskaran --14dae93d930062817104e038d686

Of course. Indeed you can set TAPEDEV and LTAPEDEV in your onconfig file to filesystem directory names and ontape will automatically manage the filenames even for multiple server instances. So, just mount a filesystem from your NAS disk array to say /informix/archives and create two directories there say /informix/archives/backups and /informix/archives/logs. Then set the ONCONFIG variables to: TAPEDEV=/informix/archives/backups TAPESIZE=0 LTAPEDEV=/informix/archives/logs LTAPESIZE=0 Then all you need to do is continue running ontape as you have been doing: For archives: ontape -s -L 0 For logs: ontape -a --or-- ontape -c Art Art S. Kagel 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 Fri, Jun 28, 2013 at 11:50 AM, medkba <medkba@gmail.com> wrote: > Hi All, > > Currently, we are doing database backup Level 0 and Logical Log backup on > to tape drives. > > Is it possible to change to NAS disk instead of tape drives. > > We are using Informix 11.50 on HP-UX machine. > > If yes, please let me know the statement or script for this > > Thank you very much > > Regards > Baskaran > > --14dae93d930062817104e038d686 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3ca14cff82104e03b547f

Art, Thank you for the information and I have seeing onconfig parameter is as below TAPEDEV /dev/rmt/2m TAPEBLK 2048 TAPESIZE 100000000 LTAPEDEV /dev/rmt/0m LTAPEBLK 1024 LTAPESIZE 2048000 and changes as below TAPEDEV=/informix/archives/backups TAPEBLK 2048 TAPESIZE=0 LTAPEDEV=/informix/archives/logs LTAPEBLK 1024LTAPESIZE=0 Please let me know if it correct changes and I need one more information do you require to equal sign or just space enough Thank you very much Regards Baskaran On Sat, Jun 29, 2013 at 2:49 AM, Art Kagel <art.kagel@gmail.com> wrote: > Of course. Indeed you can set TAPEDEV and LTAPEDEV in your onconfig file > to filesystem directory names and ontape will automatically manage the > filenames even for multiple server instances. So, just mount a filesystem > from your NAS disk array to say /informix/archives and create two > directories there say /informix/archives/backups and > /informix/archives/logs. Then set the ONCONFIG variables to: > > TAPEDEV=/informix/archives/backups > TAPESIZE=0 > LTAPEDEV=/informix/archives/logs > LTAPESIZE=0 > > Then all you need to do is continue running ontape as you have been doing: > For archives: ontape -s -L 0 > For logs: ontape -a --or-- ontape -c > > Art > > Art S. Kagel > 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 Fri, Jun 28, 2013 at 11:50 AM, medkba <medkba@gmail.com> wrote: > > > Hi All, > > > > Currently, we are doing database backup Level 0 and Logical Log backup on > > to tape drives. > > > > Is it possible to change to NAS disk instead of tape drives. > > > > We are using Informix 11.50 on HP-UX machine. > > > > If yes, please let me know the statement or script for this > > > > Thank you very much > > > > Regards > > Baskaran > > > > --14dae93d930062817104e038d686 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c3ca14cff82104e03b547f > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34dec31182c04e043a5e1

Spaces between the keywords in the onconfig file and the value, not equals signs. Otherwise looks good. Art Art S. Kagel 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 Sat, Jun 29, 2013 at 12:44 AM, medkba <medkba@gmail.com> wrote: > Art, > > Thank you for the information and I have seeing onconfig parameter is as > below > > TAPEDEV /dev/rmt/2m > TAPEBLK 2048 > TAPESIZE 100000000 > > LTAPEDEV /dev/rmt/0m > LTAPEBLK 1024 > LTAPESIZE 2048000> > and changes as below > TAPEDEV=/informix/archives/backups > TAPEBLK 2048 > TAPESIZE=0> > LTAPEDEV=/informix/archives/logs > LTAPEBLK 1024> LTAPESIZE=0 > > Please let me know if it correct changes and I need one more information do > you require to equal sign or just space enough > > Thank you very much > > Regards > Baskaran > > On Sat, Jun 29, 2013 at 2:49 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > Of course. Indeed you can set TAPEDEV and LTAPEDEV in your onconfig file > > to filesystem directory names and ontape will automatically manage the > > filenames even for multiple server instances. So, just mount a filesystem > > from your NAS disk array to say /informix/archives and create two > > directories there say /informix/archives/backups and > > /informix/archives/logs. Then set the ONCONFIG variables to: > > > > TAPEDEV=/informix/archives/backups > > TAPESIZE=0 > > LTAPEDEV=/informix/archives/logs > > LTAPESIZE=0 > > > > Then all you need to do is continue running ontape as you have been > doing: > > For archives: ontape -s -L 0 > > For logs: ontape -a --or-- ontape -c > > > > Art > > > > Art S. Kagel > > 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 Fri, Jun 28, 2013 at 11:50 AM, medkba <medkba@gmail.com> wrote: > > > > > Hi All, > > > > > > Currently, we are doing database backup Level 0 and Logical Log backup > on > > > to tape drives. > > > > > > Is it possible to change to NAS disk instead of tape drives. > > > > > > We are using Informix 11.50 on HP-UX machine. > > > > > > If yes, please let me know the statement or script for this > > > > > > Thank you very much > > > > > > Regards > > > Baskaran > > > > > > --14dae93d930062817104e038d686 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a11c3ca14cff82104e03b547f > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c34dec31182c04e043a5e1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c67605eff7d04e0675477