Installing Db2 (Windows)

This task describes how to download and install the Db2 Community Edition for Windows. Db2 Community Edition is a full-featured server installation. After a three-month trial period, you can apply either a Standard or Advanced license to receive product support and more features.

Before you begin

Before you download and install Db2 Community Edition, complete the following preliminary tasks:
  • If you are planning on setting up a partitioned database environment, refer to Setting up a partitioned database environment.
  • Ensure that your system meets installation, memory, and disk requirements.
  • If you are planning to use LDAP to register the Db2 server in Windows operating systems Active Directory, extend the directory schema before you install. Otherwise, you must manually register the node and catalog the databases. For more information, see Extending the Active Directory Schema for LDAP directory services (Windows).
  • You must have a local Administrator user account with the recommended user rights to install Db2.
    Under certain conditions, a nonadministrator user with elevated privileges can install Db2 Community Edition for Windows:
    • The target database server must exist where LocalSystem can be used for the Db2 instance user.
    • The database partitioning feature (DPF) must not be in use.
  • Close all programs so that the installation program can update any files on the computer without requiring a restart.
  • Installing Db2 products from a virtual drive or an unmapped network drive (such as \\hostname\sharename in Windows Explorer) is not supported. Before you attempt to install Db2 products, you must map the network drive to a Windows drive letter (for example, Z:).
The following restrictions apply when you are installing Db2 Community Edition for Windows:
  • You cannot have more than one instance of the Db2 Setup wizard that is running in any user account.
  • The Db2 copy name and the instance name cannot start with a number.The Db2 copy name is limited to 64 English characters that consists of the characters A-Z, a-z and 0-9.
  • The Db2 copy name and the instance name must be unique among all Db2 copies.
  • The use of XML features is restricted to a database that has only one database partition.
  • If you installed one of the following products, then no other Db2 database product can be installed in the same path:
    • IBM® Data Server Runtime Client
    • IBM Data Server Driver Package
  • The Db2 Setup wizard fields do not accept non-English-language characters.
  • If you enable extended security on Windows or higher, the users must belong to the DB2ADMNS or DB2USERS group to run local Db2 commands and applications. This setup is needed because of an extra security feature (User Access Control) that limits the privileges that local administrators have by default. If users do not belong to one of these groups, they do not have read-only access to local Db2 configuration or application data.

Procedure

Use the Db2 Setup wizard to define your installation and install your Db2 database product on your system.

To install Db2 Community Edition on a Windows workstation or server, complete the following steps:

  1. Go to the Db2 Download page and sign in with your IBM account credentials.
  2. Choose your contact option, review the Terms and Conditions, and then click Continue.
  3. From the Downloads page that appears, locate the IBM® Db2 11.5 Edition for Windows® on AMD64 and Intel® EM64T systems option and click the associated Download now link.
  4. From the pop-up box that appears, choose Save File.

The file is downloaded to your browser's default location on your Windows server.

  1. Log on to the system with the local Administrator account.
  2. Using Windows Explorer, locate the v11.5_ntx64_dec.zip file that you downloaded and extract it to the wanted location on your server.
  3. Expand the extracted folder, \v11.5_ntx64_dec\SERVER_DEC\image, right-click the setup.exe file and select Run as administrator to start the Db2 Setup Launchpad.

Attention: You must never start the installation package(".msi" file) present in the Db2 installation media directly. Installation must always be started by running setup.exe with full administrative privileges.

  1. If a User Account Control window is displayed, click Yes.
  2. Click Install a Product.
  3. Scroll to the end of the Db2 Version 11.5.0.0 Server Editions and click Install New.
  4. Click Next to begin the installation.
  5. Review the software license agreement, click the option to accept, and then click Next.
  6. Select the Typical install option and then click Next.
  7. Select the option, Install Db2 Server Edition on this computer and save my settings in a response file and then click Next.
  8. Accept the default install path and then click Next.
  9. Select the option, Do no autostart the IBM SSH server at system startup and then click Next.
  10. From the Domain drop-down list box, select None- use local user account as the domain name, enter and confirm a password, and then click Next.
  11. Accept Db2 as the default instance and then click Next.
  12. Ensure that the Set up your Db2 server to send notifications checkbox is NOT SELECTED and then click Next.
  13. Select the option, enable operating system security for Db2 objects, and then click Next.
  14. When the Start copying files window is displayed, click Finish.
  15. When the setup is complete, click Finish.

Results

Your Db2 database product is installed, by default, in the Program_Files\IBM\sqllib directory, where Program_Files represents the location of the Program Files directory.

If you are installing on a system where this directory is already being used, the Db2 database product installation path has _xx added to it. The xx are digits, starting at 01 and increasing, depending on how many Db2 copies you installed.

You can also specify your own Db2 database product installation path.

What to do next

  • Verify your installation. You can use the db2val tool for verification.
  • Complete the necessary post-installation tasks.

For information about errors that are encountered during installation, review the installation log file that is located in the My Documents\DB2LOG\ directory. The log file uses the following format: DB2-ProductAbrrev-DateTime.log, for example, DB2-ESE-Tue Apr 04 17_04_45 2012.log.

If you are doing a new Db2 product installation on Windows 64−bit, and you use a 32−bit OLE DB provider, you must manually register the IBMDADB2 DLL. To register this DLL, run the following command: 
c:\windows\SysWOW64\regsvr32 /s c:\Program_Files\IBM\SQLLIB\bin\ibmdadb2.dll
where Program_Files represents the location of the Program Files directory.

IBM Data Studio can be installed by running the Db2 Setup wizard.