We are having some problems administering HADR on a new installation.
Specifically, we are seeing that the connection status of the pair is
"disconnect ed". We have restarted, restored, and even rebooted to no
avail. In the diag log we are seeing lots of "External Comm Error".
The machines can see each other on the network, and in fact we can
start HADR on both machines from the primary (without specifying BY
FORCE). Once HADR is started, we have one PRIMARY and one STANDBY, but
the pair shows status disconnected. I'm not sure what else to try...
anyone have any ideas what could be causing this?
5  9628 
"Brian" <bv*******@yaho o.com> a écrit dans le message de
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . We are having some problems administering HADR on a new installation.
Specifically, we are seeing that the connection status of the pair is
"disconnect ed". We have restarted, restored, and even rebooted to no
avail. In the diag log we are seeing lots of "External Comm Error".
The machines can see each other on the network, and in fact we can
start HADR on both machines from the primary (without specifying BY
FORCE). Once HADR is started, we have one PRIMARY and one STANDBY, but
the pair shows status disconnected. I'm not sure what else to try...
anyone have any ideas what could be causing this?
Hi Brian,
I don't think the messages you get are related to HADR, but I wish IBM
change these "External Comm Error" that pollute the db2diag.log... Please,
why don't you make this in Information Level ?
Regards,
Jean-Marc
Brian wrote: We are having some problems administering HADR on a new installation.
Specifically, we are seeing that the connection status of the pair is
"disconnect ed". We have restarted, restored, and even rebooted to no
avail. In the diag log we are seeing lots of "External Comm Error".
The machines can see each other on the network, and in fact we can
start HADR on both machines from the primary (without specifying BY
FORCE). Once HADR is started, we have one PRIMARY and one STANDBY, but
the pair shows status disconnected. I'm not sure what else to try...
anyone have any ideas what could be causing this?
Does the pair ever get to peer state?
No it never does make it to peer state. If we restore the secondary
from backup, it will show 'peer' for a brief moment, but then shows
disconnected within a few seconds. This leads me to believe that
there's some issue with transferring the logs, but I'm not sure how to
troubleshoot this issue more.
Thanks,
Brian
Ok, change in status. It seems one of our databases had a 'deactivate'
command issued against it. When we ran a 'db2 activate ...' command
from the command line, we got to peer state. But... the mode shows
'asynchronous', despite the fact that we configured both databases to
run in 'synchronous'. We have restarted both databases, but still
can't get to synchronous. If we do a "db2 get db cfg for testing1" on
the command line, we see that the mode show async for both databases.
I thought we could just change the mode through the gui, then restart
the database for changes to take effect. Is this true?
Thanks
I'm not very familiar with the GUI, but maybe some final "take action"
step was overlooked. Anyway, once the configuration change is made on
both systems, and both are recycled, there obviously should be no
drifting of configuration values. If you'd like an alternative to the
GUI, then you can change the configuration using CLP commands, for
example:
db2 update db cfg for <db-name> using HADR_SYNCMODE SYNC
Regards,
-Steve P.
--------------------------------------
Steve Pearson
DB2 UDB for LUW Development
Portland, OR, USA
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: RMG |
last post by:
I use VS.net 2003 and VSS 6a.
Whilst working on the network the integration between
VS.net and VSS works perfectly. But when I open a project
whilst disconnected from the network I get some problems.
When I open a solution VS.net tells me it can't find the
VSS database and gives me an option to "work
disconnected". If I select this option VS.net gives me a
msgbox titled "Microsoft Development Environment" with the
|
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: 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: 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...
| | |
by: shorti |
last post by:
I have two questions about HADR recovery. I am running db2 v8 fp12.
1) If the primary suddenly crashes would you always want to switch the
standby to the primary by force...or would there be times when you
would want to make it a standard? (and why)
2) Let us say the primary suddenly crashes (someone pulled the power
cable) and you switch the standby to primary by force. Then you bring
the primary back up and issue a START as...
|
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: tensi4u |
last post by:
Hi,
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...
|
by: agentlease |
last post by:
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.
|
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: 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: 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: 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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
