Oninit cdi / Archive
Talk to an expert →

HDR Interval

Posted in 2004

Topics: High Availability & Replication, Backup & Restore, Logging & Checkpoints, Platform-Specific Issues

Trev — — source: Usenet: comp.databases.informix

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

↪ replying to Trev
Fernando Nunes — — source: Usenet: comp.databases.informix

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.

Glossary