Hai everyone......
i was trying to implement the HADR concept
........ i tried using the following commands ......
On server_1
db2 backup database prod to /backup_dir
db2 update db cfg for prod using
HADR_LOCAL_HOST server_1
HADR_REMOTE_HOS T server_2
HADR_LOCAL_SVC port_s1
HADR_REMOTE_SVC port_s2
HADR_REMOTE_INS T db2inst2
db2 start hadr on database prod as primary
On server_2
db2 restore database prod from /backup_dir
db2 update db cfg for prod using
HADR_LOCAL_HOST server_2
HADR_REMOTE_HOS T server_1
HADR_LOCAL_SVC port_s2
HADR_REMOTE_SVC port_s1
HADR_REMOTE_INS T db2inst1
db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot
start hadr... can anyone tell me do i need to do anything other than
this ........... pls let me know if anything wrong........
Thanks
Kamal.... 6 2449
"Gladiator" <vk************ @gmail.com> wrote in message
news:11******** **************@ r2g2000cwb.goog legroups.com... Hai everyone...... i was trying to implement the HADR concept ....... i tried using the following commands ......
On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1 HADR_REMOTE_HOS T server_2 HADR_LOCAL_SVC port_s1 HADR_REMOTE_SVC port_s2 HADR_REMOTE_INS T db2inst2 db2 start hadr on database prod as primary
On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_2 HADR_REMOTE_HOS T server_1 HADR_LOCAL_SVC port_s2 HADR_REMOTE_SVC port_s1 HADR_REMOTE_INS T db2inst1 db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........
Thanks Kamal....
Don't issue the command "db2 start hadr on database prod as primary" until
you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log
path, etc).
Mark A wrote: "Gladiator" <vk************ @gmail.com> wrote in message news:11******** **************@ r2g2000cwb.goog legroups.com... Hai everyone...... i was trying to implement the HADR concept ....... i tried using the following commands ......
On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1 HADR_REMOTE_HOS T server_2 HADR_LOCAL_SVC port_s1 HADR_REMOTE_SVC port_s2 HADR_REMOTE_INS T db2inst2 db2 start hadr on database prod as primary
On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_2 HADR_REMOTE_HOS T server_1 HADR_LOCAL_SVC port_s2 HADR_REMOTE_SVC port_s1 HADR_REMOTE_INS T db2inst1 db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........
Thanks Kamal....
Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log path, etc).
Thanks a lot....
kamal
Mark A wrote: "Gladiator" <vk************ @gmail.com> wrote in message news:11******** **************@ r2g2000cwb.goog legroups.com... Hai everyone...... i was trying to implement the HADR concept ....... i tried using the following commands ......
On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_1 HADR_REMOTE_HOS T server_2 HADR_LOCAL_SVC port_s1 HADR_REMOTE_SVC port_s2 HADR_REMOTE_INS T db2inst2 db2 start hadr on database prod as primary
On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_HOST server_2 HADR_REMOTE_HOS T server_1 HADR_LOCAL_SVC port_s2 HADR_REMOTE_SVC port_s1 HADR_REMOTE_INS T db2inst1 db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........
Thanks Kamal....
Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log path, etc).
Now its working....... Does the stand by database automatically takes
over after the primary one fails??? or do we need to manually give the
takeover command........ ...
"Gladiator" <vk************ @gmail.com> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. . Mark A wrote: "Gladiator" <vk************ @gmail.com> wrote in message news:11******** **************@ r2g2000cwb.goog legroups.com... > Hai everyone...... > i was trying to implement the HADR concept > ....... i tried using the following commands ...... > > On server_1 > db2 backup database prod to /backup_dir > db2 update db cfg for prod using > HADR_LOCAL_HOST server_1 > HADR_REMOTE_HOS T server_2 > HADR_LOCAL_SVC port_s1 > HADR_REMOTE_SVC port_s2 > HADR_REMOTE_INS T db2inst2 > db2 start hadr on database prod as primary > > On server_2 > db2 restore database prod from /backup_dir > db2 update db cfg for prod using > HADR_LOCAL_HOST server_2 > HADR_REMOTE_HOS T server_1 > HADR_LOCAL_SVC port_s2 > HADR_REMOTE_SVC port_s1 > HADR_REMOTE_INS T db2inst1 > db2 start hadr on database prod as standby > > > but when i am giving tht "db2 start hadr " command its giving cannot > start hadr... can anyone tell me do i need to do anything other than > this ........... pls let me know if anything wrong........ > > > Thanks > Kamal.... >
Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log path, etc). Now its working....... Does the stand by database automatically takes over after the primary one fails??? or do we need to manually give the takeover command........ ...
NO automatic failover will happen !!
One thing you absolutely want to prevent is having 2 primaries.
And this might happen when doing an automatic failover where -for example-
the primary's network interface may fail for a few seconds, the standby
takes over HADR, and then the primary returns again.
Knokmans
Gladiator wrote: Mark A wrote:
"Gladiator" <vk************ @gmail.com> wrote in message news:11****** *************** *@r2g2000cwb.go oglegroups.com. ..
Hai everyone...... i was trying to implement the HADR concept ....... i tried using the following commands ......
On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_H OST server_1 HADR_REMOTE_ HOST server_2 HADR_LOCAL_S VC port_s1 HADR_REMOTE_ SVC port_s2 HADR_REMOTE_ INST db2inst2 db2 start hadr on database prod as primary
On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_H OST server_2 HADR_REMOTE_ HOST server_1 HADR_LOCAL_S VC port_s2 HADR_REMOTE_ SVC port_s1 HADR_REMOTE_ INST db2inst1 db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........
Thanks Kamal....
Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log path, etc).
Now its working....... Does the stand by database automatically takes over after the primary one fails??? or do we need to manually give the takeover command........ ...
Manual, but there are 3rd party products that can automate it ... e.g.
TSA, VCS.
Larry Edelstein
Larry wrote: Gladiator wrote: Mark A wrote:
"Gladiator" <vk************ @gmail.com> wrote in message news:11****** *************** *@r2g2000cwb.go oglegroups.com. ..
Hai everyone...... i was trying to implement the HADR concept ....... i tried using the following commands ......
On server_1 db2 backup database prod to /backup_dir db2 update db cfg for prod using HADR_LOCAL_H OST server_1 HADR_REMOTE_ HOST server_2 HADR_LOCAL_S VC port_s1 HADR_REMOTE_ SVC port_s2 HADR_REMOTE_ INST db2inst2 db2 start hadr on database prod as primary
On server_2 db2 restore database prod from /backup_dir db2 update db cfg for prod using HADR_LOCAL_H OST server_2 HADR_REMOTE_ HOST server_1 HADR_LOCAL_S VC port_s2 HADR_REMOTE_ SVC port_s1 HADR_REMOTE_ INST db2inst1 db2 start hadr on database prod as standby
but when i am giving tht "db2 start hadr " command its giving cannot start hadr... can anyone tell me do i need to do anything other than this ........... pls let me know if anything wrong........
Thanks Kamal....
Don't issue the command "db2 start hadr on database prod as primary" until you have started HADR on standby first.
Also, make sure you have logretain on (or using exit program or archive log path, etc).
Now its working....... Does the stand by database automatically takes over after the primary one fails??? or do we need to manually give the takeover command........ ... Manual, but there are 3rd party products that can automate it ... e.g. TSA, VCS.
Larry Edelstein
Thanks a lot everyone....... ......
Regards...
kamal This thread has been closed and replies have been disabled. Please start a new discussion. 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: 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: 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: 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: 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: 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: 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?
| |