Upgrade essentials for clients
Upgrading clients to Db2® version 11.1 requires an understanding of upgrade concepts, upgrade options, upgrade restrictions, upgrade recommendations, and connectivity between clients and Db2 servers.
After you have a complete understanding of what upgrading your clients involves, you can create your own plan to successfully upgrade your clients to Db2 version 11.1.
In the upgrading client topics, the term pre-Db2 version 11.1 clients refers to version 10.1, and version 9.7 clients.
- Upgrade options for clients
- The upgrade options vary depending on the type of client that you want to install. The following table describes the upgrade options for each type of Db2 version 11.1 client:
Table 1. Upgrade options for Db2 version 11.1 clients Upgrading from Upgrading to Upgrade support details
- version 10.1 Data Server Client
- version 9.7 Data Server Client
Db2 version 11.1 Data Server Client(Windows) You have two options:
- Install the Db2 version 11.1 Data Server Client, and choose a pre-Db2 version 11.1 client copy with the upgrade action in the Work with Existing window. The client instance is then automatically upgraded for you.
- Install a new copy of the Db2 version 11.1 Data Server Client, and then manually upgrade existing client instances.
- version 10.1 Data Server Runtime Client
- version 9.7 Data Server Runtime Client
Db2 version 11.1 Data Server Runtime Client(Windows)
- Install the Db2 version 11.1 Data Server Runtime Client as a new copy, and then manually upgrade your existing client instance.
All version 10.1, or version 9.7 clients (Linux® or UNIX) All Db2 version 11.1 clients (Linux or UNIX)
- Install a new copy of any Db2 version 11.1 client, and then manually upgrade your existing client instance.
When you upgrade a client instance, the bit size is determined by the operating systems where you installed the Db2 version 11.1 client. Refer to Table 1 for details.
- Upgrade restrictions for clients
Review Upgrade restrictions for Db2 servers for information regarding instance upgrade and operating system support. These restrictions also apply to clients and can impact their upgrade.
Also, the trusted context capability supports only the TCP/IP protocol. Any connections to upgraded databases that you cataloged using a local node are unable to use this capability unless you recatalog the nodes using the TCP/IP protocol.
- Connectivity support between clients and Db2 servers
- In Db2 version 11.1, the following support for connectivity between clients and Db2 servers is available:
Table 2. Db2 version 11.1 connectivity support Client Db2 server Client connectivity support 32-bit or 64-bit Db2 version 11.1 clients 32-bit or 64-bit Db2 version 11.1 server version 11.1 clients other than the IBM® Data Server Driver for JDBC and SQLJ can establish 32-bit or 64-bit connections. For the IBM Data Server Driver for JDBC and SQLJ:
- With type 4 connectivity, a 32-bit or 64-bit Java™ application can connect to a 32-bit or 64-bit server.
- With type 2 connectivity
- A 32-bit or 64-bit Java application can make a remote connection to a 32-bit or 64-bit server.
- A 64-bit Java application can make a local connection to a 32-bit or 64-bit server.
- A 32-bit Java application can make a local connection only to a 32-bit server.
32-bit or 64-bit Db2 version 9.7 clients 32-bit or 64-bit Db2 version 11.1 server Only Db2 version 9.7 or earlier functionality is available. 32-bit or 64-bit version 10.1 clients 32-bit or 64-bit Db2 version 11.1 server Only Db2 version 10.1 or earlier functionality is available.
Connections to Db2 Version 9.1 servers from a version 11.1 client is supported. However, Db2 Version 9.1 reached end of support on April 30, 2012. For more support lifecycle information, see http://www-01.ibm.com/software/data/support/lifecycle/. For continued Version 9.1 support, a service extension is required.
Besides connectivity support, if you issue Db2 commands or SQL statements from a client to a Db2 server with a different version, you must be aware of incompatibilities between releases that can arise from changes in default behavior or restrictions lifted for these commands or SQL statements.
For example, if you issue the DESCRIBE command with the INDEXES FOR TABLE parameter from a Db2 version 11.1 client, a pre-Db2 version 11.1 server lists only relational indexes while a Db2 version 11.1 Db2 server lists indexes over XML data and text search indexes in addition to relational indexes. Refer to Upgrade impact from Db2 command changes and Upgrade impact from SQL statement changes for details.