If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > hadr standby

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-12-12, 10:02
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
hadr standby

we have db2 ese on p/linux 9.5 fp8
we are using hadr and tsa in an instance with many db's
we wanted to apply some maintenance
applied the maintenance on standby server first. - ok
now doing a takeover on all databases to free the primary server
at that time (while takeover running) I was disconnected from vpn and lost connection with these machines
after logon again we stated 1 database on both servers in standby mode
I tried all kind of commands - stop hadr - deactivate - takeover force to try to release one of these db - no success
finally I dropped the db and restored db with rollforward
I could see in another pmr a similar situation but they don't provide much detail

has anybody lived such a scenario and how did you get out of this ?
can a rollforward be executed (after you can stop hadr I presume) ?


this was the text from the other pmr
-------------
I had the customer try and connect to the "primary" database and it said
it was still in HADR standby mode. I had the customer stop HADR on the
primary, deactivate the database, stop HADR on the "standby" and then
activate the "primary". He had to rollforward through the logs to get
it to deactivate but was able to do so. He deactivated successfully,
stopped HADR, the activated the database and is able to connect without
further issue.
------

any idea/help is welcome - many thanks ..
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #2 (permalink)  
Old 01-15-12, 11:47
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
You can view pmrs opened by other customers? I tried "Search for service requests" opened by all customers, but it seems I can only see pmrs opened by my customer #
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On