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 > Urgently question about HADR

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-17-11, 09:38
Junior DBA Junior DBA is offline
Registered User
 
Join Date: Sep 2011
Posts: 11
Urgently question about HADR

Plz, could you help me to get these points more clear?

1. I need to know how takeover can occur automatically in HADR, instead of manually running command ... db2 takeover hard on db by force
(Where the second node automatically be primary just when failure occur in the first node)

Hint: in my environment I have no SAN or even shared resource

2. According to my information, HADR applied only on each database alone.
(So if I have 30 databases in the instance I should configure HADR on each database alone)
Can I make HADR on instance level instead of on database level?

Thanks in advance ..
Reply With Quote
  #2 (permalink)  
Old 11-17-11, 09:46
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
1. You need cluster manager software, such as Tivoli System Automation, which comes free with DB2. This software is used to detect system problems and issue HADR takeover commands.

2. No, you cannot set up HADR at the instance level.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 11-17-11, 10:03
Junior DBA Junior DBA is offline
Registered User
 
Join Date: Sep 2011
Posts: 11
Thanks very much

but i read little about TSA and i found that it need shared

if my information is true, is there were another way to apply TSA and avoid using shared ?
else could u clarify the idea of TSA or give me link that help me more.
Reply With Quote
  #4 (permalink)  
Old 11-17-11, 11:48
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by Junior DBA View Post
Thanks very much

but i read little about TSA and i found that it need shared

if my information is true, is there were another way to apply TSA and avoid using shared ?
else could u clarify the idea of TSA or give me link that help me more.
I cannot give you a link (try google), but I am fairly sure that it can be setup with or without a shared disk, but in any case, you could easily share it via NFS mount (no SAN required).
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old 11-18-11, 02:01
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
a link and many more
Configuring a cluster using db2haicu
tsa can use a shared disk as tiebraker, default is network
there is a doc in developerswork also about this setup.. have a look
__________________
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
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