Re: tbtape help

Maury French (maury@bnr.ca) wrote: : Hello, all. Simple Question. Informix Online 5.01 running on an HP H20, hpux : 9.0. I want to backup to tape automatically, 2am or so, full backup : every night. Or should I say, level 0 archive. Anyway, the command I : believe is tbtape but it is interactive. How do I make it automatic? : Please post or email your replies, and thanks. Maury, This works, but you need to be TOTALLY CERTAIN that your entire archive will fit on one tape. If you encounter a need for a tape swap, the job will freeze up the entire database. INFORMIX> cat do_archives # #do_archives $INFORMIXDIR/bin/tbtape -s << EOF <----Note, don't type this, but this is a carriage return (^M) 0 EOF You can put do_archives in your cron file and redirect its output to a log file, like: do_archives > $INFORMIXDIR/archive.log & This provides as added feature in that you can tail the archive.log and see the output from your archive to see how far it's gotten. : |-------------------------------------------------------------------------| : |Maury French | I'm schizophrenic and so am I.. | : |email maury@bnr.ca | James Young, "Double Life" | : |phone 214-684-2603 | | : |-------------------------------------------------------------------------| -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================