script auto backup informix to disk
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
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
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.
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