Oninit cdi / Archive
Talk to an expert →

script auto backup informix to disk

Posted in 2014

Summary

Mohd Fadzil Jusoh asked for a script to back up two Informix 11.50 instances on HP-UX to disk. Lloyd Serrao posted an ontape level-0 example with environment variables, and a TAPEDEV directory with TAPEBLK and TAPESIZE settings. Art Kagel advised a cron job that sets the environment per instance and runs ontape or onbar, or letting a storage manager such as Tivoli schedule it.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

MOHD FADZIL JUSOH — — source: IIUG Forums & Mailing Lists

hi, We have 2 informix 11.50 production instance on HP-UX 11.3 I want to create backup script on HP-UX to auto backup my informix data to disk. Please advice. tq

↪ replying to MOHD FADZIL JUSOH
LLOYD SERRAO — — source: IIUG Forums & Mailing Lists

You can use the below script - export INFORMIXDIR=/users/informix export ONCONFIG=onconfig.inew export INFORMIXSERVER=inew export PATH=/users/informix/bin:$PATHexport OUTFILE=/users/informix/tmp/ontape.log echo '\\ 0' | ontape -s -L 0 | head -100 > /users/informix/tmp/ontape_bkup.log

↪ replying to LLOYD SERRAO
LLOYD SERRAO — — source: IIUG Forums & Mailing Lists

Your TAPEDEV settings in oncofing file would be like this TAPEDEV /users/informix/backup TAPEBLK 64 # Tape block size (Kbytes) TAPESIZE 1024000 # Maximum amount of data to put on tape (Kbytes) you can tune this to suit your requirement.

↪ replying to MOHD FADZIL JUSOH
Art Kagel — — source: IIUG Forums & Mailing Lists

You just have to have a cron job wake up, set the environment variables so it can access one or the other Informix instance, and then run ontape or onbar as appropriate. If you are using onbar with a 3rd party storage manager like Tivoli you could have the storage manager schedule the backup. 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 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 Wed, Jan 8, 2014 at 3:45 AM, MOHD FADZIL JUSOH <fadzil@isianpadu.com>wrote: > hi, > > We have 2 informix 11.50 production instance on HP-UX 11.3 > > I want to create backup script on HP-UX to auto backup my informix data to > disk. > > Please advice. > > tq > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2432a477d7804ef73f01b

Related threads