Prove HADR

[juannorton]

DB2 v8.2 for win2k3 server

I configurated HADR and now I am trying it. Inside the manage option in
the control center is an option named takeover that switch the roles of
the dbs. That work perfect.

Now reading about HADR I saw that using alternate server for db using
hostname ip port # the automating reroute will start. I got a java web
application running on tomcat. The configuration parameters in tomcat
show the ip address of the machine that runs the database.

How can I automate the rerouting proces in that case?
Someone told me about virtual IP but where can I find information about
configurating that for win2k3?

Thanks
Juan

[Serge Rielau]

ju********@gmail.com wrote:

DB2 v8.2 for win2k3 server

I configurated HADR and now I am trying it. Inside the manage option in
the control center is an option named takeover that switch the roles of
the dbs. That work perfect.

Now reading about HADR I saw that using alternate server for db using
hostname ip port # the automating reroute will start. I got a java web
application running on tomcat. The configuration parameters in tomcat
show the ip address of the machine that runs the database.

How can I automate the rerouting proces in that case?
Someone told me about virtual IP but where can I find information about
configurating that for win2k3?

Thanks
Juan

I'm far from an expert on this topic, but AFAIK you need to set up
"automatic client reroute". Time too google information center :-)

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Steve Pearson (news only)]

Client reroute can be configured at the server or via the universal
JDBC driver (if you're using that). In neither case is the IP address
failed over.

http://publib.boulder.ibm.com/infoce...n/c0011976.htm

http://publib.boulder.ibm.com/infoce...d/cjvclrrt.htm

Regards,
- Steve P.
-----------------------------
DB2 UDB Development
Portland, OR

[juannorton]

Steve, I saw the links that you put and the second one seems pretty
good to me, because I am using JDBC.

Now in the text says:

"...DB2 Universal JDBC Driver client reroute support causes the
underlying connection to be rerouted to an alternate location where a
failover replica of the database resides..."

"...Alternates are propagated from the server to the client dynamically
when the client issues a CONNECT or CONNECT RESET. This dynamically
propagated alternate server information is stored in global driver
memory, and is also updated in the JNDI store of DB2 active servers..."

From that I understood that using UPDATE ALTERNATE SERVER command I am configurating the JDBC am I right?

Any examples for that?

Thanks

Serge Rielau wrote: ju********@gmail.com wrote:

DB2 v8.2 for win2k3 server

I configurated HADR and now I am trying it. Inside the manage option in
the control center is an option named takeover that switch the roles of
the dbs. That work perfect.

Now reading about HADR I saw that using alternate server for db using
hostname ip port # the automating reroute will start. I got a java web
application running on tomcat. The configuration parameters in tomcat
show the ip address of the machine that runs the database.

How can I automate the rerouting proces in that case?
Someone told me about virtual IP but where can I find information about
configurating that for win2k3?

Thanks
Juan

I'm far from an expert on this topic, but AFAIK you need to set up
"automatic client reroute". Time too google information center :-)

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Steve Pearson (news only)]

Caveat: I am not expert in the JDBC driver.

From what I've been told, the driver can have alternative server

information set up for it in two different ways:

- via a specific API of the driver, the client on its own can set up
alternate server information

- upon connecting to the server, if the server has alternate server
info defined, it will be passed back to the client; in this case, it
will overwrite (update) any value that the client had initially set on
its own

Some additional information is here:
http://publib.boulder.ibm.com/infoce...2130.htm#wq460

(For some reason, IE won't go directly to the internal location #wq40
for me. If same holds for you, you may end up at the top of
"Documentation updates" page. Search down for "Rerouting DB2 Universal
JDBC driver clients".)

I'm not sure what examples you may be wanting. There is an example of
the UPDATE ALTERNATE SERVER command in the first topic link in my prior
reply. There are some examples having to do with the universal driver
under the other link in my first reply and the link just above in this
reply.

Regards,
- Steve P.
--------------------------------
DB2 UDB Development
Portland, OR