MPP versions

For MPP versions, modify the file $DB2InstHome/sqllib/db2nodes.cfg with the hostname that you want each database partition to start on. DB2 automatically changes and updates the db2nodes.cfg file to enable the database partitions to fail over from one node to another. DB2 adds a fourth column for the "netname". "The netname" is by default the hostname. The virtual IP is not used in the db2nodes.cfg file for MPP configurations.

For example:

0 sysA 0
1 sysB 0
2 sysC 0
3 sysD 0

Make sure that the relative port number in the third column is unique for each partition on a host. For example:

0 sysA 0
1 sysA 1
2 sysB 0
3 sysC 0
4 sysD 0