RE: Unattended ontape
-> -----Original Message-----
-> From: Jonathan Leffler [mailto:jleffler@earthlink.net]
-> Sent: Saturday, April 17, 2004 8:19 AM
-> To: informix-list@iiug.org
-> Subject: Re: Unattended ontape
->
->
-> Doug Lawry wrote:
-> > Some recent threads implied that you cannot use ontape unattended.
-> > I disagree! See Shell script below.
-> >
-> > Regards,
-> > Doug Lawry
-> > www.douglawry.webhop.org
-> >
-> >
-> > # Run an automated Informix "ontape" backup
-> >
-> > # Doug Lawry, 20/11/95
-> >
-> > case $1 in
-> > '') set -- 0 ;;
-> > [012]) ;;
-> > *) echo "Usage: $0 level (0-2)" ; exit 1 ;;
-> > esac
-> >
-> > AWK='NF > 0 && $0 != last {print ; last = $0}'
-> >
-> > exec echo | ontape -s -L $1 | tr '\\b' '\\n' | awk "$AWK"
->
-> Interesting. Perfectly feasible as long as all the data always fits
-> onto one backup device. Not sufficient for the more general case
-> (larger database) where several backup devices are needed.
-> If you're
-> clever, you can use 'expect' to drive it more intelligently.
As we do every night to 5 DLT tapes in a library. Should really look at
On-Bar
I know, but the recommended storage manager (for IBM/Sequent) is
horrendously
expensive and adds complication to archiving and system backup. OnTape with
expect works well and fits our time frames, so we are happy
Keith
->
-> --
-> Jonathan Leffler #include <disclaimer.h>
-> Email: jleffler@earthlink.net, jleffler@us.ibm.com
-> Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
->
**********************************************************************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************
sending to informix-list