Creating multiple DB2 database instances on Windows
Before you begin
Complete these steps for each instance that you plan to create:
- Create a new user and add it to the Administrators group.Note: If you are using DB2®, also add the new user to the DB2ADMNS group.
- Remove the user account from the Users group.
- Grant rights to the new user:
- Click and enter secpol.msc.
- Expand Local Policies and click User Rights Assignment.
- Open each of the following rights, click Add User or Groupand add the new user:
- Act as part of the operating system
- Adjust memory quotas|Increase quotas for a process
- Create a token object
- Debug programs
- Lock pages in memory
- Log on as a service
- Replace a process level token
Tip: The new account uses the local system as the domain.
Procedure
Attention:
To create DB2 database instances on Windows, follow these steps:- For each instance that you want to create, log in as the instance owner before creating the instance.
- Use the DB2 Command Line Processor to enter commands.
- After creating the instance, add the instance to the user environment variable. The instance is then visible in the DB2 Control Center.