Upgrading to Data Server Client (Windows)
Upgrading an existing client copy to Db2® version 11.1 requires that you install a version 11.1 Data Server Client copy and then upgrade your client instance to retain your client configuration and to connect to all your previously cataloged databases.
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 Db2 clients and Db2 servers in upgrade essentials for Db2 clients.
- Perform pre-upgrade tasks for Db2 clients.
Refer to Pre-upgrade tasks for clients.
About this task
When you install a Db2 version 11.1 Data Server Client, you can choose to automatically upgrade an existing pre- version 11.1 client copy.
Your existing client instances are upgraded to a new Db2 version 11.1 Data Server Client copy and the existing pre- version 11.1 client copy is removed.
You can also choose to install a new copy of Db2 version 11.1Data Server Client and then manually upgrade your existing client instance after installation.
The bit size of the client instance is determined by the operating system where you install a Db2 version 11.1 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.
To upgrade from an existing client copy to a Db2 version 11.1 Data Server Client on Windows:
Data Server Client by
running the setup command to launch the Db2 Setup
wizard. You have three choices:
Select the Work with Existing option on the Install a Product panel. Then in the Work with an existing Db2 copy window, select a client copy name with action upgrade. The selected Db2 copy is removed and your client instance is upgraded. You can choose this option if you have an existing copy of Version 9.7 Data Server Client or Version 10.1 Data Server Client
Select the Install New option in the Install a Product panel. You should choose this option to create a new copy of Db2 version 11.1 Data Server Client and keep your existing client copy. After installation, you must manually upgrade the client instance to run on the newly installed Data Server Client copy:
- Log on to the system as a user with Local Administrator authority.
- Run the db2iupgrade command:
where DB2PATH is set to the location that you specified during the Db2 version 11.1 Data Server Client installation and InstName is the name of the instance.
Select the Work with Existing option on the Install a Product panel. Then in the Work with Existing window, choose the client copy name with the upgrade action. Finally, in the Select the installation, response file creation, or both window, select the Save my installation setting in a response file option to create a response file for a response file installation. The response file has the required UPGRADE_PRIOR_VERSIONS keyword, the client copy name to upgrade, and the installation path.
The result of the response file installation will be the same as in the first choice, all your client instances running on the selected client copy are automatically upgraded to the Db2 version 11.1 Data Server Client copy. Using a response file installation to upgrade your clients can help you automate the upgrade process when you have a large number of clients.
- If you want your applications to use the Db2 version 11.1 Data Server Client copy through the default interface set the Db2 version 11.1 Data Server Client copy as the Db2 default copy.
You can create a new Db2
version 11.1 client instance instead of upgrading the existing client instance. You only
need to create a new
version 11.1 client instance when you want to keep multiple client copies running on the
same machine, or create a testing environment. To create a
client instance, run the db2icrt command with the option -s:
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 save in the pre-upgrade tasks.
"%DB2PATH%"\bin\db2icrt -s client InstName
- Compare the upgraded database manager configuration parameter values with the pre-upgrade values to ensure the changed values are compatible with your database applications.