Preparing the environment for a partitioned Db2 server (Windows)
This topic describes the steps required to prepare your Windows environment for a partitioned installation of the Db2 database product.
Before you begin
On the machine where the instance-owning partition is to be installed, have a domain user account that belongs to the local Administrators group. You log on with this account when you install Db2 database products. You must add this user account to the local Administrators group on each machine in your partitioned database environment. This account must have the Act as part of the operating system user privilege.When you add a new machine as a partition in a partitioned database environment, the new machine must have the following prerequisites:
- The same operating system version as the instance-owning machine.
- The same CPU architecture (x32 bit or x64 bit) as the instance-owning machine.
To prepare your Windows environment for installation:
- Ensure that the primary computer and participating computers
belong to the same Windows domain.
Check the domain to which the computer belongs by using the System Properties dialog, accessible through the Control Panel.
- Ensure that time and date settings on the primary computer
and participating computers are consistent. To be considered consistent, the difference in GMT time between all computers must be no greater than one hour.
System date and time can be modified using the Date/Time Properties dialog, accessible through the Control Panel. You can use the max_time_diff configuration parameter to change this restriction. The default is
max_time_diff = 60, which allows a difference of less than 60 minutes.
- Ensure that each computer object that participates in the
partitioned database environment has the "Trust computer for delegation"
privilege flagged. You can verify that the "Trust computer for delegation" check box on the General tab of each computer's account Properties dialog box in the Active Directory Users and Computers console is checked.
- Ensure that all participating computers can communicate
with each other using TCP/IP:
- On one participating computer, enter the hostname command, which will return the hostname of the computer.
- On another participating computer, enter the following
where hostname represents the hostname of the primary computer. If the test is successful, you will receive output similar to the following:
Repeat these steps until you are sure that all participating computers can communicate with each other using TCP/IP. Each computer must have a static IP address.
Pinging ServerA.ibm.com [18.104.22.168] with 32 bytes of data: Reply from 22.214.171.124: bytes=32 time<10ms TTL=128 Reply from 126.96.36.199: bytes=32 time<10ms TTL=128 Reply from 188.8.131.52: bytes=32 time<10ms TTL=128
If you are planning to use multiple network adapters, you can specify which adapter to use to communicate between database partition servers. Use thedb2nchg command to specify the netname field in the db2nodes.cfg file after the installation is complete.
During the installation you will be asked to provide a Db2 Administration Server
This is a local or domain user account that will be used by the Db2 Administration Server (DAS). The DAS is an administration service used to support the GUI tools and assist with administration tasks. You can define a user now or have the Db2 Setup wizard create one for you. If you want to create a new domain user using the Db2 Setup wizard, the account used to perform the installation must have authority to create domain users.
- Ensure that all computers in the instance have the database
directory on the same local drive letter. You can check this condition by running the GET DATABASE CONFIGURATION command and verifying the value of the dftdbpath DBM configuration parameter.
During the installation you will be asked to provide a domain user account to be associated
with the Db2
Every Db2 instance has one user assigned. The Db2 database system logs on with this user name when the instance is started. You can define a user now, or you can have the Db2 Setup wizard create a new domain user for you.
When adding a new node to a partitioned environment the Db2 copy name must be the same on all computers.If you want to create a new domain user using the Db2 Setup wizard, the account used to perform the installation must have authority to create domain users. The instance user domain account must belong to the local Administrators group on all the participating computers and will be granted the following user rights:
- Act as part of the operating system
- Create token object
- Lock pages in memory
- Log on as a service
- Increase quotas
- Replace a process level token
If extended security was selected, the account must also be a member of the DB2ADMNS group. The DB2ADMNS group already has these privileges so the privileges are already explicitly added to the account.