473,890 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Virtual IP addresses with HADR in addtion to automatic client reroute

A consultant has recommended to us that we use virtual IP addresses for our
HADR databases (the virtual IP address is moved when the primary database is
moved to other server), even though automatic client reroute should be able
to point applications to the correct primary HADR database. The consultant
is concerned about a split brain (both servers think they are the primary),
especially when the original primary server crashes, an HADR takeover by
force is issued on the standby, and then the server is brought back
on-line..

I have not seen anything in IBM documentation or the TSA/HADR white papers
that recommends using virtual IP addresses if automatic client reroute is
available. Does anyone have thoughts or real world experiences on this
issue?
Jan 23 '06 #1
0 2347

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2202
by: Mark A | last post by:
Anyone running HADR using VERITAS Cluster Server (VCS)? Our production outsourcing company has recommended to use VCS instead of Tivoli System Automation (TSA) for heartbeat monitoring on Linux. Another question. We assume that automatic client reroute can be used with Type 4 drivers for J2EE, and that we the type 4 driver version that is distributed with DB2 Release 8.2. Is that correct? What is the typical delay that people are...
3
3034
by: Pab | last post by:
I'm trying to use the client reroute feature of the DB2 Universal JDBC driver. I found documentation on this in the "Application Development Guide: Programming Client Applications" in the section "DB2 Universal JDBC client reroute support". In order to implement client reroute, we need to use the class DB2ActiveServerList. However, this class is not present in the file IBM\SQLLIB\java\db2jcc.jar (couldn't find the file...
7
10675
by: Mark A | last post by:
If server 01 running HADR in the primary role crashes, and the DBA does a HADR takeover by force on the 02 server to switch roles, then the 02 server is now the primary. What happens when the Server 01 is brought back up? It still thinks it is the primary because that was its role when it crashed and it does not know about the takeover by force command that was issued. Does the 01 server check the 02 server to see what role they are in...
7
5071
by: Marc | last post by:
Hi, I'm working with a customer that is trying to find a solution to provide geographical redundancy. Our application is currently using IBM DB2 v8.2. I have a couple of questions with regards to HADR: 1. DB2 HADR (Can it be used to support geographical redundancy in a nested fashion (ie. Synchronous HADR at a site, and ASYNCRONOUS between sites using the same instances/databases). If so how would we set it up?
1
3918
by: Mark A | last post by:
DB2 ESE 8.2.3 (FP10) for Linux We are experiencing a connection hang of 10 - 15 minutes in the following HADR and automatic client reroute scenario: 01 server is primary database 02 server is standby database a. applications connected to database on 01 server b. shutdown 01 server
6
4090
by: RayRay | last post by:
I was hoping I might be able to get an answer regarding DB2 and HADR. Let me preface this by saying that I know very little about networking and I'm not familiar with the HADR product or clustering. But, I've been asked to research a couple issues for a client. They are thinking about implementing HADR. They have DB2 production databases running on more than one box. Does a liscense for HADR need to be purchased for each production box...
1
3341
by: Hobbit | last post by:
Hi, I want to test HADR in a windows environment. As default in DB2 there's only a manual takover possible. Are there some scripts available how I can automate this? I've found only some whitepapers with an automatic takover with HACMP and TSA. Regards Hobbit
2
4132
by: Laurence | last post by:
Hi there, Anybody knows should I also implement Automatic Client Reroute if I did HACMP and DB2 HADR on AIX? Thanks in advance,
1
2196
by: joshdevins | last post by:
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 own DataSource but the DB2Driver. Does anybody know if this will still work, or if there is a way to do automatic reroute without the DB2DataSource. Or better yet, how to make this all...
0
9812
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10899
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10446
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8004
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5832
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6032
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4655
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4255
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3263
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.