HADR - AIX - DB2 Database

agentlease

Hi,

If the HADR state is 'Disconnected' and commit transactions to the
Primary database, in the event of a Failover to the Standby database,
how do we determine if it is safe i.e. how do we know how far behind
the standby database is?

Basically what is the procedure to determine if it's safe to do a
failover to the standby with a takeover hadr .....force.

Nov 2 '08 #1

Subscribe Reply

3314

Mark A

<ag********@hot mail.comwrote in message
news:04******** *************** ***********@x16 g2000prn.google groups.com...

Hi,

If the HADR state is 'Disconnected' and commit transactions to the
Primary database, in the event of a Failover to the Standby database,
how do we determine if it is safe i.e. how do we know how far behind
the standby database is?

Basically what is the procedure to determine if it's safe to do a
failover to the standby with a takeover hadr .....force.

It is only safe to do a takeover by force if the primary server is not
available to the application (crashed, network connection is not accessible,
etc). If you are automating the takeover with a Cluster Manager, then make
sure your instance is not on autostart.

You can run a command on the primary and standby to see where the log
position is. Normally if they are in peer state you can run it from either
server, but if in disconnected state you would have run it on each server to
get the log position of each. You have two choices:

db2 get snapshot for database on <dbname(there is section on HADR in the
output)
db2pd -d <dbname-hadr

Nov 2 '08 #2

Steve Pearson (news only)

You may also want to look at the HADR Peer Window feature, which can
help ensure that transactions do not commit on the primary without
replication to the standby, for a configurable period of time. This
is useful where there is a high desire for consistency at failover,
and esp. where failover is automated. Note that this choice for
consistency does trade off against availability, as when the HADR pair
is disconnected, the primary (in SYNC or NEARSYNC modes) cannot commit
transactions during Peer state, nor in the new Disconnected Peer state
that comes with the Peer Window feature.

Some intro material here:

http://publib.boulder.ibm.com/infoce.../c0051997.html

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

Nov 13 '08 #3

Similar topics

3104

Running a HADR script outside of the HADR Wizard

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.

DB2 Database

5228

Why are 2 ports required for a HADR Pair?

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.

DB2 Database

10620

HADR split brain question

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...

DB2 Database

4648

HADR and failed tablespace creation

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

DB2 Database

21801

Unable to start HADR reason code 7

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...

DB2 Database

23476

Start hadr primary db failed with SQL1768N, reason code 7.

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

DB2 Database

4088

DB2 HADR software

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...

DB2 Database

21969

start hadr as standby fails with SQL1767N rc=1

by: shorti | last post by:

db2 8.1 fix pack 12 on AIX 5.3 This is a newly configured HADR machine. The HADR was up and running. I was 'playing' around some on the standby and did a db2 deactivate and things sort of went down hill from there. Though the Standby machine seemed to know it was a standby it would not connect to the primary. I could not even do a db2 get snapshot to view the hadr status on the machine. I was wanting to do a few HADR tests before I...

DB2 Database

2441

Few Questions with HADR - 1

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 Database

4047

Db2 9.5 HADR failures on Linux Susie 10 on multi servers\VM ware

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. ...

DB2 Database

9423

Changing the language in Windows 10

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,...

Windows Server

10210

Problem With Comparison Operator <=> in G++

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...

C / C++

9990

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9861

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7406

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6672

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3956

transfer the data from one system to another through ip address

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

C# / C Sharp

3561

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2814

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General