db2 9.1 HADR + WAS 6.0.2 + type 4 driver

Raf Mathijs

db2 9.1 HADR + WAS 6.0.2 + type 4 driver
can anyone help me what steps I should undertake to make the alternate
server adress of the hadr couple persistent over jvm's ( when jvm would go
down was can reconnect normally to alternate adress when failed over)

because the documentation i find seems unclear, jndi datasources tcr4bind ...

would you advise someone to use this with the type 4 driver or to don't
bother with all this and use the type 2 driver instead

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

[login to unmask email]

Re: db2 9.1 HADR + WAS 6.0.2 + type 4 driver
(in response to Raf Mathijs)
Hello Raf,

If I understand you correctly you want a solution for the following
situation:
HADR DB2 with failing primary server
Failing jvm which should connect to the alternate server after it is
started again

The type 4 driver supports automatic client rerouting. You should
configure the DataSource property "clientRerouteServerListJNDIName".
This list can be made persistent across jvms.

A good description on how to configure clientRerouteServerListJNDIName
is in the redbook "High Availability and Scalability Guide for DB2 on
Linux, UNIX, and Windows"

Groeten,
Bart

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raf Mathijs
Sent: Wednesday, January 02, 2008 3:55 PM
To: [login to unmask email]
Subject: [DB2-L] db2 9.1 HADR + WAS 6.0.2 + type 4 driver

can anyone help me what steps I should undertake to make the alternate
server adress of the hadr couple persistent over jvm's ( when jvm would
go
down was can reconnect normally to alternate adress when failed over)

because the documentation i find seems unclear, jndi datasources
tcr4bind ...

would you advise someone to use this with the type 4 driver or to don't
bother with all this and use the type 2 driver instead

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms