DB2 Version 9.7 for Linux, UNIX, and Windows

Installing IBM data server clients (Windows)

If the machine already has a prior version of a client installed, you should first review topics that cover upgrading.

If the machine already has a DB2 server product installed, it is not necessary to install a client because the DB2 server provides all the capability found in an IBM data server client.

Prerequisites

Before installing IBM data server clients or client package:

• You have determined which client best suits your need.
• You have located a DVD or other install image that you need. Ensure you have the appropriate 32-bit or 64-bit version, depending on your machine.
• You have a Windows® user account that is part of the Administrators group.
  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 product. The VS2005 runtime library is needed on the operating system before the DB2 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.
• Your system meets all memory, disk space, and installation requirements. The installation program will check disk space and basis system requirements, and notify you if there is a problem.

Restrictions

• No other DB2 product can be installed in the same path if one of the following products 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.

This procedure covers the simple case. Information for other cases is covered elsewhere in this topic. To install any IBM data server client on Windows:

1. Log on to the system with the user account that you want to use to perform the installation.
2. Optional: Shut down any other programs.
3. Insert the DVD into the drive. The auto-run feature starts the DB2 Setup wizard which determines the system language and starts the setup program for that language.

   For the Data Server Client, you can run the DB2 Setup wizard in a language other than the default system language by manually invoking the DB2 Setup wizard and specifying a language code. For example, the setup -i fr command runs the DB2 Setup wizard in French. For the Data Server Runtime Client or Data Server Driver Package, there are separate install images for each language.

4. To install an IBM data server client or client package:
   • If you are installing a Data Server Client, launch the DB2 Setup wizard, when the DB2 Launchpad opens, choose Install a Product. Follow the DB2 Setup wizard's prompts.
   • If you are installing a Data Server Runtime Client, it does not have a launchpad. See the Related Links for setup command parameters.

     If you are installing a second copy of the Data Server Runtime Client, the command is:

     setup /v" TRANSFORMS=:InstanceId1.mst MSINEWINSTANCE=1"

     To install each subsequent copy of the Data Server Runtime Client (up to a maximum of 16 copies), modify the command by incrementing InstanceIdn, for example:

     setup /v" TRANSFORMS=:InstanceId2.mst MSINEWINSTANCE=1"

     Note:
     It is strongly recommended that installing multiple copies is for advanced users.
   • If you are installing Data Server Driver Package, run the setup command from the product DVD. If you are installing a fix pack image, see the Related Links for the installation command options of the setup command.

     If you are installing a second copy of Data Server Driver Package, the following methods can be used:

     • To perform a new copy installation with a generated default copy name:

       setup /o

     • If the copy name already exists, perform a maintenance (or upgrade) installation on that copy. Otherwise, perform the new installation by using the specified copy name.

       setup /n copyname

     After installing Data Server Driver Package, you can optionally create and populate the configuration file, db2dsdriver.cfg, with database directory information.

5. If you are installing a Data Server Client on a machine that already has a DB2® Universal Database™ (UDB) Version 8 copy installed, you will be presented with the option to install a new copy or to upgrade the DB2 UDB Version 8 copy.

   Installing a new copy preserves the DB2 UDB Version 8 copy and installs an additional DB2 Version 9 copy. Choosing to upgrade will copy the DB2 UDB Version 8 client instance settings to the DB2 Version 9 copy then remove the DB2 UDB Version 8 copy.

   Note:
   If a machine already has a DB2 UDB Version 8 copy installed, the Version 9 copies cannot be set to default.

   If you are installing a Data Server Runtime Client, the installation program always installs a new copy. To upgrade a DB2 UDB Version 8 client instance as a subsequent step, see topics on migration.

After completing this procedure, the product is now installed at the location you specified during the installation. As part of the IBM Data Server Client installation procedure, an instance of the DB2 database manager is created. The instance is called "DB2" if there is no other instance called "DB2". If you already have a copy of DB2 Version 8 or DB2 Version 9.1 installed, the default instance is DB2_01.

The default installation path of Data Server Client and Data Server Runtime Client is Program Files\IBM\sqllib. If a second copy is installed in the same machine, the default directory name is Program Files\IBM\sqllib_01. In general, the default directory name is sqllib_nn where nn is the number of copies installed in that machine minus one.

The default installation path of Data Server Driver Package is Program Files\IBM\IBM DATA SERVER DRIVER. If a second copy is installed in the same machine, the default directory name is Program Files\IBM\IBM DATA SERVER DRIVER_02. In general, the default directory name is IBM DATA SERVER DRIVER_nn where nn is the generated number to make this directory unique.

If you want to install more than one copy of the Data Server Driver Package, you can have a maximum of 16 copies. Each copy must be installed to different directories.

The default copy name of the Data Server Client or Data Server Runtime Client is

DB2COPY1

The default copy name of the Data Server Driver Package is

IBMDBCL1

This installation does not include product documentation. See the related links for options for installing or accessing the DB2 Information Center.

After installing your IBM data server client, the next step is to configure it to access remote DB2 servers.

Notes on installing using a user account that is not a member of the Administrators group

Members of the Power Users group can install an IBM data server client. Members of the Users group can also install an IBM data server client after they have been enabled to do so. To enable members of the Users group to install an IBM data server client, a member of the Administrators group must ensure the installing user has write permission for the following:

• HKEY_LOCAL_MACHINE\SOFTWARE registry branch.
• the system directory (for example, c:\WINNT).
• the default install path (c:\Program Files) or another install path.

Of related interest, a non-administrator can also install fix packs if a non-administrator performed the original installation. However, a non-administrator cannot install fix packs if the original installation was performed by an Administrator user account.