Is there anything in Informix that

[ssgoh]

Is there anything in Informix that do database replication like what standby database do in Oracle?
Meaning, we will have a sencondary database which is idle but getting archivelogs from primary database so that it will be always standby to take over the primary database incase of anything goes wrong with primary database?

 

[olded]

Yes, it's called Informix Enterprise replication. Informix Replication assumes a secondary server which is a replica of the primary.

You can get the documentation from IBM here:

http://www-3.ibm.com/software/data/informix/pubs/library/list2.html#F

Regards,


Ed

 

[tm88gt]

Actually, HDR (High-Availability Data Replication) is very similar to Oracle's "hot-standby". It's also very easy to setup.