Re: Data Replication

scheer@stadt-mh.de (Dirch Scheer) wrote: >Hi Bill, >is it possible to make the secondary server to the primary after the primary >server had crashed. Is it very difficult to switch the secondary server? >We want to use replication to make our databases more reliable. The servers >are placed in different buildings, so if the primary server crashed because of >fire, the user can continue their work in the building of the secondary server >without any great time delay. Do you think, that this is prossible??? If I understand your question, I believe you are asking if you can make the secondary server the primary when the original primary has crashed and the answer is yes. There are three parameters in 7.1 HDR that controls what happens when a the primary server fails. DRAUTO=0 means that the secondary server stays in read-only mode and you have to manually switch it to be updateable, DRAUTO=1 means that the secondary is automatically switched to updateable or standard and switched back to secondary once the primary is back up and replication restarted, and DRAUTO=2 means that the secondary is automatically switched to be updateable and is also made the primary server after replication is restarted and the original primary is switched to be the secondary server. Hope this answers your question. -- Melvin Mariney, Informix DBA e-mail: melvin.mariney2@bridge.bellsouth.com