DB2 uses the $DB2InstHome/sqllib/db2nodes.cfg file during failover from one node to another.
To modify the $DB2InstHome/sqllib/db2nodes.cfg file for non-MPP versions
0 virtualhostname 0 1 virtualhostname 1
Note that the virtualhostname corresponds to the virtual IP address in the /etc/hosts file. Make sure that the virtual IP address is up and works.
With VCS, use virtual hostnames. When the service group fails over to another node, the virtual IP address is brought up on the target node. As a workaround for the limitation where the hostname entries in db2nodes.cfg need to correspond to the hostname of the node, you can use something similar to the following configuration.
On each node, create a /local/$DB2InstHome/db2nodes.cfg file with same permission as that of $DB2InstHome and create a symbolic link to this file from $DB2InstHome/sqllib/db2nodes.cfg.
# mkdir -p /local/$DB2InstHome/ # ln -s /local/$DB2InstHome/db2nodes.cfg \ $DB2InstHome/sqllib/db2nodes.cfg
The path /local/$DB2InstHome/db2nodes.cfg is local to each system. Enter the IPv6 hostname in the/local/$DB2InstHome/db2nodes.cfg on each node.
To modify the $DB2InstHome/sqllib/db2nodes.cfg file for MPP versions
For example when the high speed interconnect (FCM switch) is not used:
0 sysA 0 1 sysB 0 2 sysC 0 3 sysD 0
For example when the high speed interconnect (FCM switch) is used for inter-partition communication:
0 sysA 0 switchA 1 sysB 0 switchB 2 sysC 0 switchC 3 sysD 0 switchD
Make sure that the relative port number in the third column is unique for each partition on a host. For example when the high speed interconnect (FCM switch) is not used:
0 sysA 0 1 sysA 1 2 sysB 0 3 sysC 0 4 sysD 0
For example when the high speed interconnect (FCM switch) is used for inter-partition communication:
0 sysA 0 switchA 1 sysA 1 switchA 2 sysB 0 switchB 3 sysC 0 switchC 4 sysD 0 switchD
# source /db2_mnt/db2inst1/sqllib/db2profile
# db2greg -addvarrec variable=switchname, value=$switch
To verify the entry of switchname is the db2 global registry use the below command
# db2greg -dump