Installing Db2 (Windows)

This task describes how to start the Db2 Setup wizard on Windows. Use the Db2 Setup wizard to define your installation and install your Db2 database product on your system.

Before you begin

Before you start the Db2 Setup wizard:
  • 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 perform the installation. In Db2 database servers where LocalSystem can be used as the DAS and Db2 instance user and you are not using the database partitioning feature, a non-administrator user with elevated privileges can perform the installation.
  • Although not mandatory, it is recommended that you close all programs so that the installation program can update any files on the computer without requiring a reboot.
  • 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:).


Restrictions

  • 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 numeric value.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 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 required 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 will not have read access to local Db2 configuration or application data.

Procedure

To start the Db2 Setup wizard:

  1. Log on to the system with the local Administrator account that you defined for the Db2 installation.
  2. If you have the Db2 database product DVD, insert it into the drive. If enabled, the auto-run feature automatically starts the Db2 Setup Launchpad. If the autorun does not work, use Windows Explorer to browse the Db2 database product DVD and double-click the setup icon to start the Db2 Setup Launchpad.
  3. If you downloaded the Db2 database product from Passport Advantage®, run the executable file to extract the Db2 database product installation files. Use Windows Explorer to browse the Db2 installation files and double-click the setup icon to start the Db2 Setup Launchpad. On Windows 2008 and Windows Vista or later versions of Windows operating system, you must right-click on setup.exe and select Run as administrator or start setup.exe from command prompt from "Command Window: Administrator".

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

  1. From the Db2 Setup launchpad, you can view installation prerequisites and the release notes, or you can proceed directly to the installation. You might want to review the installation prerequisites and release notes for late-breaking information. On Windows 2008 and Windows Vista or later versions of Windows operating system, you must right-click on setup.exe and select Run as administrator or start setup.exe from command prompt from "Command Window: Administrator".
  2. Click Install a Product and the Install a Product window displays the products available for installation.

    If you did not install any Db2 database products on your computer, launch the installation by clicking Install New. Proceed through the installation by following the Db2 Setup wizard prompts.

    If you installed at least one Db2 database product on your computer, you can:
    • Click Install New to create a new Db2 copy.
    • Click Work with Existing to update an existing Db2 copy, add function to an existing copy, upgrade an existing version 9.7, version 9.8, or version 10.1 copy, or to install an add-on product.
  3. The Db2 Setup wizard determines the system language, and launch the setup program for that language. Online help is available to guide you through the remaining steps. To invoke the online help, click Help or press F1. You can click Cancel at any time to end the installation.
    1. When you're at the Select the installation type step, when you click View Features... , some features are unchecked.
      1. The Connect support feature option does not affect your system’s ability to connect to Db2 for z/OS®. If you select this option, two extra trace utilities are installed. These utilities are ddcstrcn and ddcspkgn. The DDCSTRCN utility implements detailed DRDA traces and usually IBM support might request that you use this utility when they need more diagnostic data to resolve a problem. For more information about the ddcspkgn tool, see Binding applications and utilities (Db2 Connect server).
  4. Sample panels when you are using the Db2 setup wizard lead you to the installation process. See the related links.

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.
  • Perform 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 this is 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.

The Knowledge Center contains documentation for the database system and related products. By default, Db2 information is accessed from the web.

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

Db2 Workgroup Server Edition memory limits
If you are installing Db2 Workgroup Server Edition, the maximum allowed memory for the instance is 64 GB.
The amount of memory that is allocated to the instance is determined by the INSTANCE_MEMORY database manager configuration parameter.
Important notes when you upgrade from 9.7, 9.8, or 10.1:
  • The self tuning memory manager does not increase your overall instance memory limit beyond the license limits.