SEO

#1 (**permalink**) 04-20-2008, 06:40 AM

Hi,

I'm wanting to implement HDR between two IBM AIX servers running
Informix 9.4 UC3. I have 53 (2mb) logical logs.
I've been asked to have a replication period of 1 hour DRINTERVAL of
3600.
We do an ontape -c on the primary server.
Would there be a problem if all the logical logs become full before
the replication occurs? The reason for the 1 hour interval is incase
someone drops a table, or if corruption occurs, we can get the data
from the secondary box.

Any comments?

Thanks
Trevor

#2 (**permalink**) 04-20-2008, 06:40 AM

Trev wrote:
> Hi,
>
> I'm wanting to implement HDR between two IBM AIX servers running
> Informix 9.4 UC3. I have 53 (2mb) logical logs.
> I've been asked to have a replication period of 1 hour DRINTERVAL of
> 3600.
> We do an ontape -c on the primary server.
> Would there be a problem if all the logical logs become full before
> the replication occurs? The reason for the 1 hour interval is incase
> someone drops a table, or if corruption occurs, we can get the data
> from the secondary box.
>
> Any comments?
>
> Thanks
> Trevor

DR Interval won't keep the secondary server 1H behind.
It depends on many factors including logging mode for your databases and
the size of the HDR log buffer which I think can't be controlled
(directly at least).

Check previous newsgroup threads and the online manuals (Administration
Guide and Administration Reference).

Regards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

HDR Interval