NON-MPP (Single Partition)
|
Yes. Entries in the existing db2nodes.cfg is modified by adding virtual hostname. Example: db2_server |
Example:
0 db2_server 0
|
Set UseDB2start = 1. When UseDB2start is set to 1, use db2start command to start the partition. After the failover or switchover happens the entry in db2nodes.cfg remains the same.
Note: |
In this configuration the password less rsh must be set for the DB2 Instance Owner.
|
|
NON-MPP (Single Partition)
|
No
|
Example:
0 sys1 0 sys1
DB2 Installation automatically creates the above entry in db2nodes.cfg file during its installation.
Note: |
sys1/sys2 is the hostname of the physical machine. |
|
Set UseDB2start = 0. When UseDB2Start is set to 0, use db2gcf command to start the partition. After the failover/switchover happens the entry in db2nodes.cfg is updated by the hostname of the physical nodes on which the failover/switchover has happened.
For example,
when failover/switchover happens from machine sys1 to machine sys2. The existing entry in db2nodes.cf [0 sys1 0 sys1] gets changed to [0 sys2 0 sys2].
|
MPP (Multiple Partitions)
|
No
|
Example:
0 sys1 0
1 sys1 1
2 sys2 0
|
Set UseDB2start = 0. Since the number of partitions are greater that one, always use db2gcf command to start the partitions. |