469,286 Members | 2,498 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

HA for DB2

Hi all.

I have a quick question about HA. We have a setup that will be
implementing HA for DB2 ESE v8.2 FP 11 on AIX 5.3. This instance that
needs to be configured for HA was installed with the -ese because it
was only to be used for DB2 connect. Currently, we are making
available for HA the instance owner home directory and the
/etc/services file. When HA kicks in and transfers to the backup
server, the instance does not show up. DB2 works (only after moving
the /etc/services file, before doing that DB2 did not even kick up,
although it is installed on both boxes outside of HA), but the instance
does not show in db2ilist. We were thinking that there was other
files, possibly in the /etc directory, which affect the instance
working which would need to be availabla via HA to make this work. Any
thoughts?

Aug 28 '06 #1
3 1566
What "HA" are you using? It would be helpful if you described your setup.

Larry E.

rdudejr wrote:
Hi all.

I have a quick question about HA. We have a setup that will be
implementing HA for DB2 ESE v8.2 FP 11 on AIX 5.3. This instance that
needs to be configured for HA was installed with the -ese because it
was only to be used for DB2 connect. Currently, we are making
available for HA the instance owner home directory and the
/etc/services file. When HA kicks in and transfers to the backup
server, the instance does not show up. DB2 works (only after moving
the /etc/services file, before doing that DB2 did not even kick up,
although it is installed on both boxes outside of HA), but the instance
does not show in db2ilist. We were thinking that there was other
files, possibly in the /etc directory, which affect the instance
working which would need to be availabla via HA to make this work. Any
thoughts?
Aug 28 '06 #2
As far as what "HA" were using, Im not sure. What I know about the
setup is that the rootvg was not copied over, only the instance owner
home directory and the /etc/services file. DB2 is installed seperately
on each box, but the theory is that the instance should replicate over
when the one box fails. This would be done when the instance owner
home directory moves over from the primary to the failover box. The
/etc/services file would move as well. I have a theory that maybe the
instance needs to be installed seperately on each box for this to work
as DB2 is installed seperately. There are many many guides on doing
this with normal DB2 setups that have databases, but for a box that
only will be using DB2 connect, I cannot find any recommendations.
Please help!
Larry wrote:
What "HA" are you using? It would be helpful if you described your setup.

Larry E.

rdudejr wrote:
Hi all.

I have a quick question about HA. We have a setup that will be
implementing HA for DB2 ESE v8.2 FP 11 on AIX 5.3. This instance that
needs to be configured for HA was installed with the -ese because it
was only to be used for DB2 connect. Currently, we are making
available for HA the instance owner home directory and the
/etc/services file. When HA kicks in and transfers to the backup
server, the instance does not show up. DB2 works (only after moving
the /etc/services file, before doing that DB2 did not even kick up,
although it is installed on both boxes outside of HA), but the instance
does not show in db2ilist. We were thinking that there was other
files, possibly in the /etc directory, which affect the instance
working which would need to be availabla via HA to make this work. Any
thoughts?
Aug 28 '06 #3
Ian
rdudejr wrote:
As far as what "HA" were using, Im not sure. What I know about the
setup is that the rootvg was not copied over, only the instance owner
home directory and the /etc/services file. DB2 is installed seperately
on each box, but the theory is that the instance should replicate over
when the one box fails. This would be done when the instance owner
home directory moves over from the primary to the failover box. The
/etc/services file would move as well. I have a theory that maybe the
instance needs to be installed seperately on each box for this to work
as DB2 is installed seperately. There are many many guides on doing
this with normal DB2 setups that have databases, but for a box that
only will be using DB2 connect, I cannot find any recommendations.
Please help!
Generally when setting up HA (regardless of the which vendor's HA
implementation you are using) you should issue the 'db2icrt' command
on both servers. This updates files in /var/db2 (which the db2i*
commands read).

Usually this involves creating a temporary file system on the standby
server has the same mount point as the instance owner's home directory
on the primary server, running db2icrt, and then removing the file
system.

Also, you shouldn't need to copy /etc/services every time, unless (for
some odd reason) you are constantly changing the contents of this file.

Aug 29 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.