HADR

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gladiator - 23 Jun 2006 09:33 GMT

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

Reply to this Message

Mark A - 23 Jun 2006 09:36 GMT

> Hai everyone......
> i was trying to implement the HADR concept
[quoted text clipped - 26 lines]
> 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).

Reply to this Message

Gladiator - 23 Jun 2006 11:45 GMT

> > Hai everyone......
> > i was trying to implement the HADR concept
[quoted text clipped - 32 lines]
> Also, make sure you have logretain on (or using exit program or archive log
> path, etc).

Thanks a lot....

kamal

Reply to this Message

Gladiator - 23 Jun 2006 12:33 GMT

> > Hai everyone......
> > i was trying to implement the HADR concept
[quoted text clipped - 32 lines]
> 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...........

Reply to this Message

Knokmans - 23 Jun 2006 13:42 GMT

>> > Hai everyone......
>> > i was trying to implement the HADR concept
[quoted text clipped - 38 lines]
> 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

Reply to this Message

Larry - 23 Jun 2006 13:46 GMT

>>>Hai everyone......
>>> i was trying to implement the HADR concept
[quoted text clipped - 36 lines]
> 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

Reply to this Message

Gladiator - 23 Jun 2006 13:58 GMT

> >>>Hai everyone......
> >>> i was trying to implement the HADR concept
[quoted text clipped - 41 lines]
>
> Larry Edelstein

Thanks a lot everyone.............

Regards...
kamal

Reply to this Message