DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading to Data Server Runtime Client (Windows)

Upgrading an existing Runtime Client copy to DB2® Version 9.7 requires that you install a Version 9.7 Data Server Runtime Client copy and then upgrade your client instance to retain your client configuration and to connect to all your previously cataloged databases

After you install a Version 9.7 Data Server Runtime Client copy, you can manually upgrade your existing client instance from a Version 8 DB2 Run-Time, Version 8 DB2 Run-Time Client Lite copy, Version 9.1 DB2 Runtime Client copy, or a Version 9.5 Data Server Runtime Client.

About this task

Restrictions

The bit size of the client instance is determined by the operating systems where you install Version 9.7 client. The instance is 32-bit only in 32-bit Windows on x86 or x64. The instance is 64-bit only in 64-bit Windows on x64. Refer to Table 1 for details.

Before you begin

Ensure that you have SYSADM, SYSCTRL, or SYSMAINT authority and Local Administrator authority to run the db2iupgrade and the db2icrt commands.
Review supported connectivity between clients and DB2 servers in upgrade essentials for clients.
Perform pre-upgrade tasks for clients.

Procedure

To upgrade from a Version 8 DB2 Run-Time, Version 8 DB2 Run-Time Client Lite, or a Version 9.1 DB2 Runtime Client copy to Version 9.7 Data Server Runtime Client on Windows:

Install Version 9.7 Data Server Runtime Client. Run v9.7fpX_ntYY_rtcl.exe to launch the DB2 Setup wizard for all languages, where X is the fix pack version and YY is the bit version of Windows (32 or 64). For English only, run v9.7fpX_ntYY_rtcl_EN.exe, where X is the fix pack version and YY is the bit version of Windows (32 or 64).
If you want your applications to use the Version 9.7 Data Server Runtime Client copy through the default interface or if you upgraded your existing Version 8 client copy, set the Version 9.7 Data Server Runtime Client copy as the DB2 default copy.
Log on to the system as a user with Local Administrator authority.
Upgrade your existing client instance by running the db2iupgrade command:
```
   "%DB2PATH%"\bin\db2iupgrade InstName
```
where DB2PATH is set to the location that you specified during the Version 9.7 Data Server Runtime Client installation and InstName is the name of the instance.
Optional: You can create a new Version 9.7 client instance instead of upgrading an existing client instance. You only need to create a new Version 9.7 client instance when you want to keep multiple client copies running on the same machine. To create a new Version 9.7 client instance, run the db2icrt command with the option -s:
```
   "%DB2PATH%"\bin\db2icrt -s client InstName
```
To create the same client connectivity environment you had, including the database manager configuration parameter and DB2 profile registry settings, run the db2cfimp command with the configuration profile that you saved in the pre-upgrade tasks.
Compare the upgraded database manager configuration parameter values with the pre-upgrade values to ensure the changed values are compatible with your database applications.

What to do next

After upgrading your client, perform the recommended post-upgrade tasks for clients, especially verifying upgrade for clients to ensure that your client upgrade was successful.