Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2008

Tip: Looking for answers? Try searching our database.

V9.5 HADR On AIX

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
agentlease@hotmail.com - 29 Oct 2008 10:55 GMT
Hi,

Testing the above without TSA or HA, just plain HADR performing manual
db2 TAKEOVER HADR ......................... etc.

I am testing without the PEER_WINDOW i.e. set to 0  and HADR_SYNCMODE
= SYNC.

A quick question, say the primary and standby database servers are in
PEER state and the primary database server suddenly crashes through a
panic etc. What is the procedure to determine if forced takeover on
the standby database server can be issed without the loss of data.

Is there a set of rules or procedure?

Many Thanks.
Mark A - 29 Oct 2008 12:17 GMT
> Hi,
>
[quoted text clipped - 12 lines]
>
> Many Thanks.

There will be no loss of data, because the standby server will rollback the
uncommitted transactions, just as will the primary server when it is brought
back up and goes into crash recovery.

You will loose data that has not be been committed on the primary server,
but that has nothing to do with HADR and is normal for all modern database
systems.

BTW, you might want to consider using Nearsynch instead of Synch mode. The
only difference is that in synch mode DB2 guarantees that the logs have been
sent to the standby and written to the HADR buffer and also written to disk
on the standby when a transaction is committed; whereas with Nearsynch DB2
guarantees that the logs have been written to the HADR buffer on the standby
(which eventually will get written to disk). It is inconceivable to me how
one could loose any data with nearsynch unless that standby server crashed a
few milliseconds after the primary server crashed. If that happened (both
servers crashed at the same time) you would not do a takeover to the standby
server (since it would also be down), so you could not loose any data, and
when you brought the primary and standby server back up, the logs would get
in synch.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.