473,320 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

HADR

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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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....

Jun 23 '06 #1
6 2428
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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).
Jun 23 '06 #2

Mark A wrote:
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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).



Thanks a lot....

kamal

Jun 23 '06 #3

Mark A wrote:
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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...........

Jun 23 '06 #4

"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Mark A wrote:
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.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_HOST server_2
> HADR_LOCAL_SVC 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_HOST server_2
> HADR_REMOTE_HOST server_1
> HADR_LOCAL_SVC 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...........

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
Jun 23 '06 #5
Gladiator wrote:
Mark A wrote:
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googleg roups.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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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
Jun 23 '06 #6

Larry wrote:
Gladiator wrote:
Mark A wrote:
"Gladiator" <vk************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googleg roups.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_HOST server_2
HADR_LOCAL_SVC 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_HOST server_2
HADR_REMOTE_HOST server_1
HADR_LOCAL_SVC 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

Jun 23 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
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...
3
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.
7
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...
4
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...
16
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...
8
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 ...
6
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...
6
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...
0
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
0
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.