469,903 Members | 1,997 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

HACMP + DB2 HADR vs Automatic Client Reroute

Hi there,

Anybody knows should I also implement Automatic Client Reroute if I did
HACMP and DB2 HADR on AIX?
Thanks in advance,

Dec 23 '06 #1
2 3947
When you implement HADR on your systems, one of the things you'll need to do
is to update the the environment of the servers you have.
On the primary, issue:
db2 ? update alternate server for ....
Usage notes 7
7
a.. This command is only applied to the system database directory.
7
b.. This command should only be used on a server instance. If it is issued
7 on a client instance, it is ignored and message SQL1889W is returned.
7
c.. If Lightweight Directory Access Protocol (LDAP) support is enabled on
the 7 machine on which the command is issued, the alternate server for the
database will be automatically 7 registered in the LDAP directory.

When the client connects to its db, it will pick up and return the info. so
that it will know where to go when the standby takes over from the primary.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Laurence" <wo**********@gmail.coma ecrit dans le message de news:
11**********************@i12g2000cwa.googlegroups. com...
Hi there,

Anybody knows should I also implement Automatic Client Reroute if I did
HACMP and DB2 HADR on AIX?
Thanks in advance,
Dec 23 '06 #2
Yes, I did Automatic Client Reroute as well.

For your reference~

Jan 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by juannorton | last post: by
1 post views Thread by Mark A | last post: by
3 posts views Thread by Mark A | last post: by
7 posts views Thread by Mark A | last post: by
7 posts views Thread by Marc | last post: by
16 posts views Thread by gumby | last post: by
1 post views Thread by joshdevins | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.