I have sucessfully set up an HADR pair of databases. Everthing works
fine for the primary and secondary HADR databases, and manual takeover
works fine.
When I try to set up the second pair of databases for HADR in the same
instance, I get the following error message (I already sucessfully
started the standby database):
$ db2 start hadr on db tdsapp as primary
SQL1768N Unable to start HADR. Reason code = "99".
In the Messages and Codes manual, Reason code 99 says:
"The primary and standby databases are able to connect via TCP/IP, but
the connection had to be closed due to an incompatibility between the
two databases. Refer to the Administration Notification log for details
of the incompatibility ."
I cannot find the "Administra tion Notification log" but here is the
contents of the db2diag.log:
2005-11-02-17.18.52.343701 +000 I1041212G318 LEVEL: Warning
PID : 13542 TID : 4063074816 PROC : db2hadrp
(TDSAPP) 0
INSTANCE: db2inst8 NODE : 000 DB : TDSAPP
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP,
probe:20301
MESSAGE : Info: Primary Started.
2005-11-02-17.18.52.343997 +000 E1041531G432 LEVEL: Error (OS)
PID : 13542 TID : 4063074816 PROC : db2hadrp
(TDSAPP) 0
INSTANCE: db2inst8 NODE : 000 DB : TDSAPP
FUNCTION: DB2 UDB, oper system services, sqloPdbBindSock et, probe:20
MESSAGE : ZRC=0x810F001B=-2129723365=SQLO _ADDR_IN_USE "Address already
in use"
CALLED : OS, -, bind OSERR: EADDRINUSE
(98)
Is there a problem in setting up 2 HADR databases in the same instance?
Any other things I should check for?
6  5247 
Does each database on a server that is configured for HADR need its own
hadr_local_svc port in /etc/services? Or can all databases on the same
server share the port?
I am not talking about the port for the instance, but for the HADR
service (hadr_local_svc ).
I tried setting up separate ports for the hadr_local_svc for each
database on the same machine that participates in HADR, and it worked.
So each DB2 database that uses HADR on a given physical server needs
its own hadr_local_svc port in /etc/services.
Yes, that's correct. Unfortunately, that information is not yet in the
main HADR documentation topics.
A documentation update exists, with the following statement:
Value restrictions for the HADR local host and local service
parameters
When specifying values for the high availability disaster recovery
(HADR) local host and local service parameters
(HADR_LOCAL_SVC and HADR_REMOTE_SVC ) while preparing
an update database configuration command, the values must be
ports that are not in use for any other service. If the parameters
are being configured using the UNIX or Linux command line,
the values should be also set in the /etc/services file.
(ref: http://publib.boulder.ibm.com/infoce...e/r0012049.htm)
Regards,
-Steve P.
------------------------------------------
Steve Pearson
DB2 UDB for LUW Development
Portland, OR, USA
"Steve Pearson (news only)" <st*******@my-deja.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . Yes, that's correct. Unfortunately, that information is not yet in the
main HADR documentation topics.
A documentation update exists, with the following statement:
Value restrictions for the HADR local host and local service
parameters
When specifying values for the high availability disaster recovery
(HADR) local host and local service parameters
(HADR_LOCAL_SVC and HADR_REMOTE_SVC ) while preparing
an update database configuration command, the values must be
ports that are not in use for any other service. If the parameters
are being configured using the UNIX or Linux command line,
the values should be also set in the /etc/services file.
(ref:
http://publib.boulder.ibm.com/infoce...e/r0012049.htm)
Regards,
-Steve P.
------------------------------------------
Steve Pearson
DB2 UDB for LUW Development
Portland, OR, USA
The updated doc still does not seem quite clear to me. I think you need to
explicitly state that each database must have its own port for
HADR_LOCAL_SVC. So if you have two databases defined for HADR on a given
server, they each must have their own port.
Here's a sneak peek at the text used in the next major docs revision,
i.e., where the document update referred to above will be taken up into
the main docs topics.
When you specify values for the high availability disaster recovery
(HADR) local service and remote service parameters
(HADR_LOCAL_SVC and HADR_REMOTE_SVC ) while preparing
an update database configuration command, the values you specify
must be ports that are not in use for any other service, including
other DB2 components or other HADR databases. In particular,
you cannot set either parameter value to the TCP/IP port used by
the server to await communications from remote clients (the
SVCENAME database manager configuration parameter) or the next
port (SVCENAME + 1).
Let me know if this is still unclear, in which case I will open a
follow-up defect report to ensure that it is revisited by the
information development folks.
Thanks.
Regards,
-Steve P.
------------------------------------------
Steve Pearson
DB2 UDB for LUW Development
Portland, OR, USA
"Steve Pearson (news only)" <st*******@my-deja.com> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com... Here's a sneak peek at the text used in the next major docs revision,
i.e., where the document update referred to above will be taken up into
the main docs topics.
When you specify values for the high availability disaster recovery
(HADR) local service and remote service parameters
(HADR_LOCAL_SVC and HADR_REMOTE_SVC ) while preparing
an update database configuration command, the values you specify
must be ports that are not in use for any other service, including
other DB2 components or other HADR databases. In particular,
you cannot set either parameter value to the TCP/IP port used by
the server to await communications from remote clients (the
SVCENAME database manager configuration parameter) or the next
port (SVCENAME + 1).
Let me know if this is still unclear, in which case I will open a
follow-up defect report to ensure that it is revisited by the
information development folks.
Thanks.
Regards,
-Steve P.
------------------------------------------
Steve Pearson
DB2 UDB for LUW Development
Portland, OR, USA
I think the reference to "or other HADR databases" is more clearly spelled
out and is satisfactory. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: shindle |
last post by:
Hello -
I am in the process of testing out the new HADR feature of DB2 UDB V8.2
and I have some questions that I was hoping that someone could answer
please.
I have a HADR test set-up with two DB2 instances on the same machine
with the sample database on each set up as an HADR pair in near-synch
mode. I have noticed that when I perform any logged operation on the
primary (such as a mass INSERT SQL) that there is a substantial lag in
|
by: bwmiller16 |
last post by:
Folks -
Linux RH3, UDB 8.2 FP9.
I've got two tiny test boxes that I'm setting up to get a simple HADR
configuration built. When I start the primary I get the famous SQL1768
RC=7 and also this on the db2diag.log.
This looks to me to be more than a simple firewall issue (which I've
checked).
|
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: 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: 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: Pat |
last post by:
Hi -
We're trying to set up an HADR pair on two databases on instances with
different names on separate servers. The databases were defined as
follows:
CREATE DATABASE database1 ON '/db2home/instanceA';
CREATE DATABASE database2 ON '/db2home/instanceB';
|
by: vbace2 |
last post by:
Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers
We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that the...
|
by: paul |
last post by:
Hi,
I have two databases in hadr, this morning i issued a "takeover ... by
force" because the normal takeover didn't worked. Now i have two standard
databases, and if i try to put the old primary database in standby mode i
can't but it's not in rollforward pending state.
How can i put this database in rollffoward pending state without
backup/restore from the new primary dabatase ?
|
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
|
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: 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,...
| | |
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: 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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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?
| |
