The database partition configuration file contains configuration information that tells DB2 which database partition on which server participates in an instance. There is a db2nodes.cfg file for each instance in a partitioned database environment.
The db2nodes.cfg file must contain one entry for each database partition on a particular server that will participate in the instance. When you create an instance, the db2nodes.cfg file is automatically created, and an entry for the instance-owning database partition is added. On Linux and UNIX, the database partition configuration file (db2nodes.cfg) uses the following format: dbpartitionnum hostname port_number netname -------------- -------- ----------- ------- 0 host1 0 net1 1 host1 1 net1 2 host2 0 net2 where: dbpartitionnum is the number DB2 uses to identify a database partition. Database partition numbers must be:
hostname is the network interface DB2 uses to communicate between database partitions.
port_number is the logical port DB2 uses to distinguish between multiple database partitions on a server. The logical port field must satisfy the following:
netname is the switch network interface DB2 uses to improve performance, specific on RS/6000 SP, using the switch technology (optional).
On Windows, the database partition configuration file (db2nodes.cfg) uses the following format: dbpartitionnum hostname machinename port_number netname -------------- -------- ----------- ----------- ------- 0 host1 machine1 0 net1 1 host1 machine1 1 net1 2 host2 machine2 0 net2 where: dbpartitionnum is the number DB2 uses to identify a database partition. Database partition number must be:
hostname is the TCP/IP host name.
machinename is the workstation name if the database partition is created on a remote machine. port_number is the logical port DB2 uses to distinguish between multiple database partitions on a server. The logical port field must satisfy the following:
netname is the network name or IP address (optional). Windows ConsiderationsFor DB2 on Windows, the database partition configuration file is created for you when you create an instance.
|