"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