DB2 Version 9.7 for Linux, UNIX, and Windows

Installing DB2 servers (Windows)

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 on Windows to register the DB2 server in Active Directory, you should extend the directory schema before you install.
• If you are planning to use the IBM® Tivoli® Monitoring for Databases: DB2 Agent, before installing your DB2 product see topic "Installing IBM Tivoli Monitoring for Databases: DB2 Agent with the DB2 installer" for details, limitations and restrictions.
• 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.
  Note:
  If a non-Administrator user account is going to do the product installation, then the VS2005 runtime library must be installed before attempting to install a DB2 database product. The VS2005 runtime library is needed on the operating system before the DB2 database product can be installed. The VS2005 runtime library is available from the Microsoft® runtime library download web site. There are two choices: choose vcredist_x86.exe for 32-bit systems or vcredist_x64.exe for 64-bit systems.
• 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 attempting 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 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 consisting 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.
• No other DB2 database product can be installed in the same path if one of the following is already installed:
  • IBM Data Server Runtime Client
  • IBM Data Server Driver Package
  • DB2 Information Center
• The DB2 Setup wizard fields do not accept non-English characters.
• If you enable extended security on Windows Vista or Windows 2008, or higher, users must belong to the DB2ADMNS or DB2USERS group to run local DB2 commands and applications 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 have defined for the DB2 installation.
2. If you have the DB2 database product DVD, insert it into the drive. If enabled, the autorun 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 on 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 on the setup icon to start the DB2 Setup Launchpad.
4. From the DB2 Setup launchpad, you can view installation prerequisites and the release notes, or you can proceed directly to the installation. You may want to review the installation prerequisites and release notes for late-breaking information.
5. Click Install a Product and the Install a Product window will display the products available for installation.

   If you have no existing DB2 database products installed on your computer, launch the installation by clicking Install New. Proceed through the installation following the DB2 Setup wizard's prompts.

   If you have at least one existing DB2 database product installed on your computer, you can:

   • Click Install New to create a new DB2 copy.
   • Click Work with Existing to update an existing DB2 copy, to add function to an existing DB2 copy, upgrade an existing DB2 Version 8, Version 9.1, or Version 9.5 copy, or to install an add-on product.
6. The DB2 Setup wizard will determine 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.

Results

Your DB2 database product will be 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 will have _xx added to it, where xx are digits, starting at 01 and increasing depending on how many DB2 copies you have 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 on errors encountered during installation, review the installation log file 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 2008.log.

If this is a new DB2 product installation on Vista 64-bit, and you will 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.

If you want your DB2 database product to have access to DB2 documentation either on your local computer or on another computer on your network, then you must install the DB2 Information Center. The DB2 Information Center contains documentation for the DB2 database system and DB2 related products. By default, DB2 information will be accessed from the web if the DB2 Information Center is not locally installed.

DB2 Express Edition and DB2 Workgroup Server Edition memory limits

If you are installing DB2 Express Edition, the maximum allowed memory for the instance is 4 GB.

If you are installing DB2 Workgroup Server Edition, the maximum allowed memory for the instance is 16 GB.

The amount of memory allocated to the instance is determined by the INSTANCE_MEMORY database manager configuration parameter.

Important notes when upgrading from Versions 9.1 or 9.5:

• If the memory configuration for your Version 9.1 DB2 database product exceeds the allowed limit, the DB2 database product might not start after upgrading to the current version.
• The self tuning memory manager will not increase your overall instance memory limit beyond the license limits.