About DB2 configurations in VCS
You can configure DB2 service groups in MPP and non-MPP configurations.
| DB2 Installation Mode | Virtual Host configured and has entry in db2nodes.cfg | Contents of Nodes.cfg | Attribute value of UseDB2Start |
|---|---|---|---|
| NON-MPP (Single Partition) | Yes. Entries in the existing db2nodes.cfg is modified by adding virtual hostname. Example: db2_server | Example\: | 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. |
| 0 db2_server 0 | Note: In this configuration the password less rsh must be set for the DB2 Instance Owner. | ||
| NON-MPP (Single Partition) | No | Example\: | 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. |
| 0 sys1 0 sys1 | For example, | ||
| DB2 Installation automatically creates the above entry in db2nodes.cfg file during its installation. | 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\]. | ||
| Note: sys1/sys2 is the hostname of the physical machine. | |||
| MPP (Multiple Partitions) | No | Example\: | Set UseDB2start = 0. Since the number of partitions are greater that one, always use db2gcf command to start the partitions. |
| - 0 sys1 0 | |||
| - 1 sys1 1 | |||
| - 2 sys2 0 |