Kbase P110640: Can I have a second target database in Fathom Replication?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/6/2009 |
|
Status: Verified
GOAL:
Can I have a second target database in Fathom Replication?
FACT(s) (Environment):
Fathom Replication 3.0A
Progress OpenEdge 10
FIX:
Fathom Replication allows for up to two target databases, though only one of the target databases can be used to automatically transition into a normal OpenEdge database. The target database that will automatically transition to a normal OpenEdge database in a failure condition is the first target database whose [control-agent.agent] properties in the server.repl.properties file has critical set to 1 and transition set to auto. If you set more than one target database to crtitical=1 and transition=auto, Fathom Replication will only recognize the first target database specified in the server.repl.properties file for automatic transition. The second database will have to be transitioned manually.
The target database you choose as critical is the database you can use as a hot standby should the source database become unavailable. This target database should be on a machine that has reliable TCP/IP connectivity and has the resources for clients to connect to and perform database updates should your source database become unavailable.
Only one target database should be designated to transition. If you transition two target databases and users make updates to both databases, you will not have a single target database with which to resource your source database.