Skip to Content
0
Apr 17, 2010 at 11:03 PM

Need Suggestion on DB2 HA Setup on AIX 6.1

37 Views

Dear All,

We are configuring HA for PRD System having below configuration:

OS: AIX 6.1

Database: DB2 9.1 Fix pack 7

System: ERP 6.0 EHP4

What we have done so far:

We have installed DB & CI on node 1 (primary node) and ASCS & Dialog Instance on node 2 (secondary node). ASCS instance on node 2 and DB on node 1 is on movable resource group. CI on node 1 and Dialog Instance on node 2 is local. So, e.g. if there is failover on node 1 then DB will move on node 2 and Dialog Instance will take over service provided by CI.

Now my doubts are:

1) I have installed DB2 in resource group and nothing local. But If I am checking redbook for HA on DB2 then it is mentioned there that we should install db2 binaries local on both nodes. Is it mandatory because my understanding is that if whole db2 is moving (log, data and binaries) then it should start there ?

2) I am using the concept of service IP's to install this HA. When I installed CI and DB on node 1 then i used hostname associated with service ip of node 1. Same when i installed ASCS and Dialog instance then I used hostname associated with service IP of node 2. And Even If I am rebooting my node 1 then all resources are going to node 2 and I am also getting hostname and service IP of node 1 on node 2. Then I think I need not to change hostname of node 1 when resources are there on node 2. Am I right ?

3) Is it necessary to catalog database on node 2 ?

4) Am I need to change host entry in db2nodes.cfg when db will move on node 2 ? My understains is that I need not to change hostname in db2nodes.cfg as I am getting ip address and hostname of node 1 on node 2. Since IP are service ip's so the host name associates with them.

Please suggest.

Thanks

Sunny