DB2 user accounts
At domain logon, users and user groups have to be created in advance as described in active directory domains registration.
During installation several local user accounts and group accounts are created in the Windows system automatically.
Group with DB2 admin rights
Group with DB2 user rights
DB2 management server (DB2DAS Windows service runs under this user)
DB2 standard instance (other DB2 Windows services run under this user)
Download DB2 installation package
For BVQ version 2.6 and later DB2 version 9.7 FP6 is required.
Visit http://www.ibm.com/support/docview.wss?rs=71&uid=swg27007053 and select DB2 version 9.7 Fix Pack 6.
Choose your operating system and download the DB2 Server Fix Pack.
To download an IBM Fix Pack a login ID is required! (create an account if necessary)
The name of the downloaded files depend on the related version:
Run the installation as a local administrator!
Unzip the installation file: v9.7fp6_nt32_server.exe or v9.7fp6_ntx64_server.exe
A target directory is arbitrary and is called in the following text [packagedir].
Afterwards restart the DB2 directory ([packagedir] \ SERVER) setup.exe.
1. Choose 'Install a product'.
2. Scroll down the selection to the product 'DB2 Express version 9.7 Fix Pack 6'.
3. Use the button below 'Install new'.
4. After start press 'Next'.
5. Read and accept the license agreements and press 'Next'.
6. Choose 'Custom installation'.
7. Choose 'Install IBM DB2 Express Edition on this computer' and press 'Next'.
8. Apply the selections of components as selected in the image and press 'Next'.
9. Chose 'English' (recommended) as the language for the user interface. Then specify the installation path for the DB2 software. Click 'Next'.
Make sure the correct destination drive is selected, if your programs are installed on another partition than C:! The location of the BVQ database is defined during the BVQ installation and may differ from this installation path.
10. Please keep the default name 'DB2COPY1'. Alternatively another name can be used, but not 'BVQ'. Click 'Next'.
11. The DB2 information center contains documents for the DB2 database, which are retrieved from the Web by default (recommended!). To do this, select the point on the IBM website. Then click 'Next'.
12. Please enter a name and password for the DB2 administrator. For a domain login, the user-account which was created in advance has to be used. For more information please see: #Active directory - domain registration. Please click 'Next'.
13. This is where the DB2 instance is listed under which the databases are running. Click 'Next'.
14. Please enter here a name and password for the DB2 instance user 'db2inst1'. For a domain login, the user-account which was created in advance has to be used. Please see: #Active directory - domain registration. Click 'Next'. .
15. Select 'Prepare DB2 tools catalog' and continue with the default settings. Click 'Next'.
16. Optionally select 'Set up your DB2 server to send notifications' to route DB2 alerts. The sending of messages can also be configured after installation. Click 'Next'.
17. Select 'Enable operating system security' and check the settings of the user groups. At domain logon the appropriate domain and the user groups which were created in advance should be selected. Please see: #Active directory - domain registration. Then click 'Next'.
18. The combined settings are listed for review. If they are correct, click 'Install'.
19. Wait until the installation is finished.
20. When the installation is completed, click 'Next'.
21. Click 'Finish'.
The DB2 installation is now complete.
Import of DB2 express OEM license
To import the DB2 licence perform the following steps as a database administrator in a DB2 command window
- Save the license file (db2exp_u.lic) in temporary folders [temp].
- Open the commandline window:
Start -> execute -> runas /user:db2admin db2cmd
At domain registration: Start -> execute ->
runas /user:[Domäne]\db2admin db2cmd
runas /user:labdr\db2admin db2cmd
- Add the new licence:
db2licm -a [temp]\db2exp_u.lic
- Removal of 'DB2 connect server':
db2licm -r db2consv
- Reset license compliance information:
- Checking licence:
The line 'Expiry date' should now contain the entry 'Permanent'.
The license file was successfully imported.