You don't say what service you are using to make the DB2 connection but
lets assume it is a java application using the JDBC driver for IBM i.
The Native connection only allows a LOCAL connection, it will not use a
network service... but it is faster (better performance).
The JDBC toolkit for IBM i, can use the network , it is a little slower.
With this driver on each connect the name is "resolved" by the
relational db entry (WRKRDBDIRE command).
If the name isn't defined, it can't connect
If you use LEI , it has it's own connector service which must be
configured and defined.
The driver changes for the type of connection and backend DB2
system.
LEI only reads the configuration on load, so to redirect LEI to
another system with the same name would require restarting LEI.
I could go on with other configuration settings but I think it would help
if you defined the environment you are trying to address.
Walter Scanlan
Senior Software Engineer
Office: 507-286-6088
Cell: 507-990-4539
From:
rob@xxxxxxxxx
To:
domino400@xxxxxxxxxxxx
Date:
02/15/2011 06:55 AM
Subject:
Domino connection to DB2 in an high availability shop
Sent by:
domino400-bounces+wscanlan=us.ibm.com@xxxxxxxxxxxx
I was looking at technical document 416466888 at
http://www-912.ibm.com/s_dir/SLKBase.nsf/1ac66549a21402188625680b0002037e/31d82ab263ae401f8625717e0068d44f?OpenDocument
So if I have GDIHQ1 and it has these entries
Name Alias Remote Location Remote Type
GDIHQ n/a *LOCAL *IP
GDIHQ GDIHQ2 GDIHQ2 *IP
And GDIHQ2 has these entries
Name Alias Remote Location Remote Type
GDIHQ n/a *LOCAL *IP
GDIHQ GDIHQ1 GDIHQ1 *IP
and we remove all host entries for GDIHQ, GDIHQ1, GDIHQ2 and our DNS
changes the IP address for GDIHQ from GDIHQ1's address to GDIHQ2's address
during the switch does that affect the Domino servers? More detail...
Let's say you have a Domino server called GDDATA which resides on GDIHQ1.
It does a connection to GDIHQ to read data. Does it
- resolve GDIHQ by reading WRKRDBDIRE first and say I'm local so I just
connect to me,
or,
- does it first discover that the address for GDIHQ is now on GDIHQ2 and
connect over there and process data?
Preliminary testing needs verification but I think it is the former and
not the latter.
What I want is that when I run my Mimix switch and Domino tries to connect
to GDIHQ it connects to GDIHQ2 instead of GDIHQ1 and read/write data on
that server.
A sample, pure out of Domino example, would be,
On GDIHQ1 I run:
PING GDIHQ and I get 10.17.1.202
PING GDIHQ1 and I get 10.10.1.201
PING GDIHQ2 and I get 10.17.1.202
NETSTAT *IFC and I get 10.10.1.201
On GDIHQ2 I run:
PING GDIHQ and I get 10.17.1.202
PING GDIHQ1 and I get 10.10.1.201
PING GDIHQ2 and I get 10.17.1.202
NETSTAT *IFC and I get 10.17.1.202
Back on GDIHQ1 I run:
STRSQL
CONNECT TO GDIHQ
Would that CONNECT TO look at WRKRDBDIRE first or would it process the
TCP/IP first?
Obvious question: Wouldn't GDDATA be down when GDIHQ is running on GDIHQ2
anyway? No. We bring the Domino servers back up ASAP after the upgrades,
saves, etc. We do not switch back from GDIHQ2 to GDIHQ1 until Sunday
evening. Often a period of 24 hours or more.
Rob Berendt
midrange.com
