473,837 Members | 1,814 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 HADR and ACR problem V9.5 on Redhat

11 New Member
I'm running two db2s v9.5 (64bit) on Redhat (64bit). I thought I finished to set up HADR and ACR successfully with CLP, the status looked good Peer, Sync, Connected, etc,. from the get snapshot command.
* I did it all with CLP, so I'm not useing DAS.

-- First
But, it doesn't seem HADR does work automatically in case of the event of failover, due to the test I killed the db2sysc process on primary. The primary was killed normally but the standby (it should be new primary) remained as "standby" in the "Remote catchup pending" status. In addition, I changed the option of db2iauto into "off" in order not to come up automatically due to split-brain.

As I know, HADR would change the role smoothly when the "failover" occurs. Do I misunderstand about the HADR's feature?

-- Second
I would like to use ACR. I set alternate server on both side, primary and standby. Whenever killed db2 process (db2sysc), I received the SQL30081N error message. The client has the tcpip and db nodes of primary only. How can I verify ACR is working properly? Did I do something wrong or miss something?

Thank you in advance.
Feb 18 '08 #1
3 3548
297 Recognized Expert Contributor

HADR does not include an automatic failover or, to use HADR dictionary, takeover. You'll have to do it manually or use a cluster/heartbeat software to automate the takeover (e.g. Tivoli Systems Automation).

Manual takeover may be done with the command

Expand|Select|Wrap|Line Numbers
Use the option BY FORCE only if you're sure the primary is as dead as a doornail and you want a quick takeover NOW.

Don't use it if the primary is still alive and you want them to exchange roles e.g. for maintenance. This will tell the primary to become secondary and vice versa.

Can't help you with ACR there, I'm sorry.



P.S.: You'll find more info about the HADR takeover procedure here.
Feb 18 '08 #2
11 New Member
Thanks Bernd, I didn't know that and found some documents related to that. It looks like it needs for me to do more jobs on this. :)

Then, how do you handle existed or new user connections (requests) in case of the event of a failover without ACR?

Feb 18 '08 #3
297 Recognized Expert Contributor
Thanks Bernd, I didn't know that and found some documents related to that. It looks like it needs for me to do more jobs on this. :)

Then, how do you handle existed or new user connections (requests) in case of the event of a failover without ACR?


you'll need a v8 or newer DB2 client for accessing the database. When connecting, the client learns that the target database is a HADR one and already gets told the data (name, address, port etc.) of the takeover server/database - just in case. If the client fails retrieving data from the primary, it's assuming it dropped dead and tries to use the secondary (which hopefully already took over).

If you switch primary/secondary for maintenance, the formerly primary will tell the client to use the other one.

Perhaps I should add that if the client is a web application server using JDBC to connect to the database, you should catalog the remote database with the local client on the web app server and point the JNDI to that local catalog entry, not directly to the remote db.


Feb 19 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Bruce M | last post by:
Is there a way to run the db2-generated HADR-create script outside of DB2CC beyond the obvious? My DB2CC generates the HADR script and then abends because of a java error meaning I can't finish my HADR creation. In looking at the script it isn't necessarily obvious which commands should run on the primary server and which should be run on the standby server.
by: bwmiller16 | last post by:
Why are 2 ports required for a HADR Pair? Environment: RH Linux AS3 UDB Express 8.2 with HADR Option Folks - Working with HADR and getting this setup to work right.
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...
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions - the tablespace is backed up on the primary system - tables are created in the new tablespace and data is inserted (and a couple of logs are archived) - Takeover is done by the standby
by: gumby | last post by:
I'm having trouble getting HADR to work with the sample databases on two HS20 xSeries blades, Red Hat ES4 up3, DB2 8.2.4, getting the following error. SQL1768N Unable to start HADR. Reason code = "7" - The primary database failed to establish a connection to its standby database within the HADR timeout interval. What things should I check besides the remote host and remote service parameters on the standby database, which seem to be...
by: Challenge | last post by:
Hi, I got error, SQL1768N Unable to start HADR. Reason code = "7", when I tried to start hadr primary database. Here are the hadr configuration of my primary db: HADR database role = STANDARD HADR local host name (HADR_LOCAL_HOST) = testserver HADR local service name (HADR_LOCAL_SVC) = 56000 HADR remote host name (HADR_REMOTE_HOST) = testserver
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...
by: deshaipet | last post by:
Hi - We have primary and standby databases on different servers. Here is my /etc/service entry for HADR pair : On Primary : "vi /etc/services
DB2 Warlord
by: DB2 Warlord | last post by:
After countless time I was unabl to find the answer to my HADR questions and getting HADR to work in 9.5 via the Control Center. Please see my fix that seem strange but works. My error was as follows. When setting up HADR via the CCenter at the last step in a full setup called "START HADR" it would fail with reason 7. Now trying to solve the port issue that is listed gets you no where. In fact on my db2diag.log it listed a comm error. ...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
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,...
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...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
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.