SEO

We had quite an interesting setup once between our PRD and hotsite which
was located too far away and the pipe was too small to use Informix HDR
(or whatever they call it these days).

We used an EXPECT script on the hotsite..... it would "sit and spin"
until a logical log bundled was ftp'd into place by the PRD script (this
script was called from Informix by $ONCONFIG setting that acts when a
log fills up (forgot the parameter)). On the PRD side the script would
only backup the logs when 5 of them were full. Then log backup would
create a bundle and then fire a script that would ftp it to the hotsite.
The hotsite was in constant logical recovery mode and the expect script
would, as I said, sit and spin, looking for a new log bundle to show up
in the right directory and then it would pick it up and feed to the
DB.....

It was really slick.
This was when we used Onarchive (yes!), now we use onbar and our hotsite
is designed differently ..... but you could probably design something
quite similar.

I don't really know perl or expect, but expect was pretty easy to pick
up/hack the existing infrastructure.

Have fun with it
Norma Jean


-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby
Sent: Saturday, September 02, 2006 2:03 PM
To: informix-list@iiug.org
Subject: Re: ontape -l roll-forward of many logs

"Paul Watson" <paul@oninit.com> wrote in message
news:1e0801c6cea1$4c7db0c0$5583390a@arnold...
> You are kidding, of course it's trivial
>
> mkfifo /tmp/mypipe
> chmod 666 /tmp/mypipe
> ontape -l < /tmp/mypipe > /tmp/ontape.out &
>
> Then write a simple awk script that reads the file /tmp/ontape.out via
> tail -f

Doesn't work for me. The script ends staright away, leaving an
zero-length
file /tmp/ontape.out (on Solaris). Where do you put the name of the
restore
file?


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
================================================== ==========
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
================================================== ==========