Upgrading clients to DB2® Version 10.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 10.1.
In the upgrading client topics, the term pre-DB2 Version 10.1 clients refers to Version 9.5, and Version 9.7 clients.
Upgrading from | Upgrading to | Upgrade support details |
---|---|---|
|
DB2 Version 10.1 Data Server Client(Windows) | You have two options:
|
|
DB2 Version 10.1 Data Server Runtime Client(Windows) |
|
All Version 9.5, orVersion 9.7 clients (Linux or UNIX) | All DB2 Version 10.1 clients (Linux or UNIX) |
|
When you upgrade a client instance, the bit size is determined by the operating systems where you installed the DB2 Version 10.1 client. Refer to Table 1 for details.
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.
Client | DB2 server | Client connectivity support |
---|---|---|
32-bit or 64-bit DB2 Version 10.1 clients | 32-bit or 64-bit DB2 Version 10.1 server | Version 10.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:
|
32-bit or 64-bit DB2 Version 9.7 clients | 32-bit or 64-bit DB2 Version 10.1 server | Only DB2 Version 9.7 or earlier functionality is available. |
32-bit or 64-bit Version 9.5 clients | 32-bit or 64-bit DB2 Version 10.1 server | Only DB2 Version 9.5 or earlier functionality is available. |
Connections to DB2 Version 9.1 servers from a Version 10.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 10.1 client, a pre-DB2 Version 10.1 server lists only relational indexes while a DB2 Version 10.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.