Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

HADR - Disconnected-Peer

 
   Database Help (Home) -> DB2 RSS
Next:  Creating an Employees' Training DB - Advice on De..  
Author Message
agentlease

External


Since: Oct 29, 2008
Posts: 7



(Msg. 1) Posted: Fri Dec 12, 2008 3:31 am
Post subject: HADR - Disconnected-Peer
Archived from groups: comp>databases>ibm-db2 (more info?)

Hi,

If I perform a Takover by force peer window only what is the
recommended action with db2 on the old primary in terms of HADR.

Thanks.

 >> Stay informed about: HADR - Disconnected-Peer 
Back to top
Login to vote
"Steve Pearson

External


Since: May 30, 2006
Posts: 8



(Msg. 2) Posted: Mon Dec 29, 2008 11:18 am
Post subject: Re: HADR - Disconnected-Peer [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This depends on what your goal is.

* One common pattern is to repair the original primary (let's call it
A) and reingetrate it into the HADR in the standby role (where
original standby B became the primary via the TAKEOVER operation).
Since your takeover using PEER WINDOW ONLY option was successful, HADR
should be able to make the two copies of the database consistent again
as long as all the intervening log files are available.

Steps would be something like:
- repair/restart host A
- start DB2 instance at A (db2start)
- activate DB2 instance at A in standby role:
START HADR ON DB <dbalias> AS STANDBY

Monitor status of the HADR pair. Once standby A catches up to primary
B and enters Peer state, the pair is now again capable of perfoming
normal failover or a role switch. The latter could be performed if
desired to place the pair in its original configuration (with A as
primary). Use a TAKEOVER command *without* the BY FORCE option at A
to perform a role switch.

* If too much time passed since A failed and it appears A may not be
able to catch up to B timely (or at all, if some log files are not
available, e.g.), another option would be to reinitialize A as standby
to the new primary B by taking a new backup of B and restoring it at
A, then starting A as standby in the usual fashion.

* Another possibility is that A no longer plays with B. Perhaps some
new copy C is created as standby to B. In any case, if A is no longer
intended to play with B, but the existing database on A is going to be
activated for some reason, then issue a STOP HADR on A so that its
existing HADR configuration does not interfere with A's new role
(otherwise, A may refuse to activate without a connection to its
expected standby B, which would not be talking to A at this point).
Note that activation can be forced using START HADR .. AS PRIMARY BY
FORCE, but that would need to be done each time until HADR is stopped.

Regards,
- Steve P.
--
Steve Pearson, DB2 for Linux, UNIX, and Windows, IBM Software Group
"Portland" Development Team, IBM Beaverton Lab, Beaverton, OR, USA

 >> Stay informed about: HADR - Disconnected-Peer 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
HADR - Hai everyone...... i was trying to implement the HADR concept ........ i tried using the following commands ...... On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1..

HADR - recovery - I have two questions about HADR recovery. I am running db2 v8 fp12. 1) If the primary suddenly crashes would you always want to switch the standby to the primary by force...or would there be times when you would want to make it a standard? (and why) ....

HADR and JBoss - Hi all, I am currently setting up our Java apps running in JBoss to use DB2 HADR capabilities with automatic reroute. My understanding is that I need to use the DB2DataSource for this to work. The problem is that the JBoss connection pooling uses it's..

HADR questions - Hi, our comapny plans to deploy SYNC mode HADR in a new production environment. I am doing the research. I have a question needs to be clarified: when network down, primary and standby databases won't be in PEER mode, although both of them up and..

HADR performance issue - Hi, I have setup a HADR between two servers in different locations. When I compare the application response time in standard environment and in HADR environment, I find the latter is more than twice slower than the former. I have tried to tune some..
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]