Installing IBM data server clients and drivers (Windows)

You can deploy your application with the IBM® Data Server Client software, the IBM Data Server Runtime Client software, or the IBM Data Server Driver Package software.

Before you begin

If you already have an IBM database server software installed, it is not necessary to install a client because the IBM database server product provides all the capability that is in a client software.

From v11 onwards, the IBM Data Server Driver provides support for Db2® Warehouse and SQLDB.

If you installed a prior version of an IBM data server client software, first review topics that cover upgrade.

The IBM Data Server Driver Package software is not part of the IBM Data Server Client or IBM Data Server Runtime Client software. The IBM Data Server Driver Package software is different, and it has its own installation images. Use the appropriate installer package.

Before you install a client software, you must determine what client software best suits your needs. Also, locate the DVD or other installation image that you need. You can download an image for a release or a fix pack from the IBM Support Fix Central site. Your Windows user account must be part of the Administrators group. If you want to use a non-Administrator user account to install the IBM database software, you must install the VS2005 runtime library first. The VS2005 runtime library is available from the Microsoft runtime library download website. Choose the vcredist_x86.exe file for 32-bit systems or the vcredist_x64.exe file for 64-bit systems. Members of the Users group can install an IBM data server client software if a member of the Administrators group ensures that the installing users have write permission for the following areas:

The HKEY_LOCAL_MACHINE\SOFTWARE registry branch
The system directory (for example, c:\WINNT)
The default installation path (C:\Program Files) or another installation path

A non-administrator can install fix packs if a non-administrator user ID was used to install the client software. However, a non-administrator cannot install fix packs if an Administrator user ID was used to install the client software. You must check that your system meets all memory, disk space, and installation requirements. The installation program checks the disk space and basis system requirements, and notifies you if there is a problem.

About this task

Restrictions

No other IBM data server software can be installed in the same path as the IBM Data Server Driver Package software.

In addition, the setup wizard fields do not accept non-English characters.

You can install a maximum of 16 copies of the Data Server Driver Package software. You must install each copy in a different directory.

If you are installing the IBM data server client software on a machine where an older version of the IBM data server client software is installed, you are presented with the option to install a new copy or to upgrade the existing copy. Installing a new copy preserves the existing copy and installs a new copy. Choosing to upgrade an existing copy to a newer installation causes the removal of existing copy. If you are installing the IBM Data Server Runtime Client software, the installation program always installs a new copy. To upgrade an existing IBM Data Server Runtime Client installation as a subsequent step, see the topics on migration.

The IBM data server client software installation does not include product documentation. For options for installing or accessing IBM Documentation, see the related links.

Procedure

To install any client software on a Windows operating system:

Log on to the system with the user account that is part of the Administrators group
Optional: Shut down other programs that are running on the computer.
Choose the installation image based on your language support requirement. Two installation images are available, which are based on the supported languages. The en_US image is for English support, while the ALL_Lang image is for all other supported languages. Choose one of the following options:
- If you received a DVD, insert it into the drive. The autorun feature starts the setup wizard, which determines the system language and starts the setup program for that language. You can run the setup wizard in a language other than the default system language by manually invoking the setup wizard and specifying a language code.
- If you downloaded an installation image, extract the file.
To install a client software, choose one of the following options.
- To install the IBM Data Server Client software, click Install a Product from the setup wizard and follow the prompts.
- To install the IBM Data Server Runtime Client, run the setup.exe command. For setup command parameters, see the Related Links.
- You can install multiple copies of the IBM Data Server Runtime Client software. To install a second copy of the IBM Data Server Runtime Client software, you can issue the following setup command:
```
setup /v" TRANSFORMS=:InstanceId2.mst MSINEWINSTANCE=1"
```
  To install each subsequent copy of the IBM Data Server Runtime Client software (up to a maximum of 16 copies), modify the command by incrementing InstanceIdn, for example:
```
setup /v" TRANSFORMS=:InstanceId2.mst MSINEWINSTANCE=1"
```
- To install the IBM Data Server Driver Package software, run the v11.5.XfpY_ntxZZ_dsdriver_EN command. The X represents the mod number value, Y represents fix pack number value, and the ZZ represents either 32-bit or 64-bit release. For fix pack number value 0, fp0 is not needed.
  To install a second copy of the IBM Data Server Driver Package software, you can use the following methods:
  - To install a new copy with a generated default copy name, you can use the following v11.5.XfpY_ntxZZ_dsdriver_EN command:
```
v11.5.XfpY_ntxZZ_dsdriver_EN /o
```
  - If a copy of the IBM Data Server Driver Package software is already installed, you can install a new copy and specify a copy name with the following setup command:
```
v11.5.XfpY_ntxZZ_dsdriver_EN /n copyname
```
  If just one copy of the IBM Data Server Driver Package software is installed, the default installation path is Program Files\IBM\IBM DATA SERVER DRIVER. For additional copies, the default directory name is Program Files\IBM\IBM DATA SERVER DRIVER_nn, where nn is the number of copies that are installed on that machine minus one. For example, if you install a second copy on the same host, the default directory name is Program Files\IBM\IBM DATA SERVER DRIVER_01.

Results

After you complete the installation steps, the software is installed at the location that you specified during the installation or the default location. As part of the IBM Data Server Client installation procedure, an instance of the database manager is created. The instance is called DB2 if there is no other instance called DB2. If you already have an installed copy of IBM data server software, the default instance is DB2_01.

For a single copy, the default installation path of the IBM Data Server Client software and the IBM Data Server Runtime Client software is Program Files\IBM\sqllib. If you install a second copy on the same machine, the default directory name is sqllib_nn, where nn is the number of copies that are installed on that machine minus one.

For a single copy, the default installation path of the Data Server Driver Package is Program Files\IBM\IBM DATA SERVER DRIVER. If you install a second copy on the same machine, the default directory name is IBM DATA SERVER DRIVER_nn, where nn is the number of copies that are installed on that machine minus one.

The default copy name of the IBM Data Server Driver Package software is IBMDBCLn, where n is the number of copies installed. The default name of the first driver on a machine is IBMDBCL1. The default name of the second driver on the machine is IBMDBCL2.

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

What to do next

After you install the IBM Data Server Driver Package software, you can optionally create the IBM data server driver configuration file (db2dsdriver.cfg) and populate it with database directory information.
After you install the IBM data server client software, the next step is to configure it to access remote IBM database servers.

For more details on Db2 Warehouse and SQLDB see the dashDB driver package topic and IBM SQL Database for Bluemix page.