I'm currently running Informix HDR (IDS 7.31 on SCO UNIX 5.0.5) in Async Mode. I just have a few questions:
In Async Mode, the log is flushed to disk without waiting for a confirmation from the Secondary.
What happens if a transaction is committed on the Primary and it suffers a failure (e.g. power outage) and the same transaction is still not committed on the Secondary (remains in Read-Only(Sec) mode)? When you bring up the Primary again, how does it know that it still needs to send the same transaction to the Secondary?
What also happens if the log is not yet flushed to disk on the Primary and a sudden failure happens? What will happen to those "dirty" logs?