DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrade essentials for clients

Upgrading clients to DB2® Version 9.7 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 9.7.

In the upgrading client topics, the term pre-Version 9.7 clients refers to Version 9.5, Version 9.1, and Version 8 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 Version 9.7 client:

Table 1. Upgrade options for Version 9.7 clients
Upgrading from	Upgrading to	Upgrade support details
Version 8 DB2 Administration Client Version 8 DB2 Application Development Client Version 9.1 DB2 Client Version 9.5 Data Server Client (Windows)	Version 9.7 Data Server Client(Windows)	You have two options: Install the Version 9.7 Data Server Client, and choose a pre-Version 9.7 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 Version 9.7 Data Server Client, and then manually upgrade existing client instances.
Version 8 DB2 Run-Time Client Version 8 DB2 Run-Time Client Lite Version 9.1 DB2 Runtime Client Version 9.5 Data Server Runtime Client (Windows)	Version 9.7 Data Server Runtime Client(Windows)	Install the Version 9.7 Data Server Runtime Client as a new copy, and then manually upgrade your existing client instance.
All Version 9.5, 9.1, or Version 8 clients (Linux or UNIX)	All Version 9.7 clients (Linux or UNIX)	Install a new copy of any Version 9.7 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 Version 9.7 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.

If you installed a Version 8 client on the same system as a DB2 Version 9.7 server or if you installed a Version 9.7 client on the same system as a DB2 Version 8 server, connections to the databases on the DB2 server from the client cataloged using a local node are not supported. You should upgrade both the DB2 server and the client to DB2 Version 9.7. If you do not upgrade the Version 8 client or the DB2 Version 8 server, you can only connect to the databases that are cataloged using TCP/IP nodes. Review the Recataloging nodes and databases using TCP/IP protocol post-upgrade task for details.

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 9.7, the following support for connectivity between clients and DB2 servers is available:

Table 2. DB2 Version 9.7 connectivity support
Client	DB2 server	Client connectivity support
32-bit or 64-bit Version 9.7 clients	32-bit or 64-bit DB2 Version 9.7 server	Version 9.7 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 Version 9.7 clients	32-bit or 64-bit DB2 Version 9.5 server	Only DB2 Version 9.5 or earlier functionality is available.
32-bit or 64-bit Version 9.7 clients	32-bit or 64-bit DB2 Version 9.1 server	Only DB2 Version 9.1 or earlier functionality is available.
32-bit or 64-bit Version 9.7 clients	32-bit or 64-bit DB2 Version 8.2 server	Only DB2 Version 8.2 or earlier functionality is available.
32-bit or 64-bit Version 9.5 clients	32-bit or 64-bit DB2 Version 9.7 server	Only DB2 Version 9.5 or earlier functionality is available.
32-bit or 64-bit Version 9.1 clients	32-bit or 64-bit DB2 Version 9.7 server	Only DB2 Version 9.1 or earlier functionality is available.
32-bit or 64-bit Version 8.2 clients	32-bit or 64-bit DB2 Version 9.7 server	Only DB2 Version 8.2 or earlier functionality is available.

Connections to DB2 Version 9.7 servers from a client release prior to Version 8.2 are not supported.

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 Version 9.7 client, a pre-Version 9.7 DB2 server lists only relational indexes while a Version 9.7 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.

Upgrade from Version 9.1 or Version 8 clients

If you are upgrading from Version 9.1 clients or earlier, review additional upgrade support changes that can also impact your upgrade: