DB2 Version 10.1 for Linux, UNIX, and Windows

Supported combinations of clients, drivers and server levels

Various versions of a client or driver can connect to different versions of a server. This includes support for earlier versions and support for accessing DB2® databases on midrange and mainframe servers.

DB2 client levels required for IBM DB2 pureScale Feature

For your application to make full use of DB2 pureScale® features, your DB2 client must be at certain release levels:

Server version	Client version	Features available
Version 9.8 or later	Version 9.7, Fix Pack 1 or later	Transaction-level and connection-level workload balancing Automatic client reroute based on workload Client affinities
Version 9.8 or later	Version 9.1, Version 9.5, or Version 9.7 (before Fix Pack 1)	Connection-level workload balancing (transaction-level workload balancing is not available) Automatic client reroute based on workload

Server version

Client version

Features available

Version 9.8 or later

Version 9.7, Fix Pack 1 or later

Transaction-level and connection-level workload balancing

Automatic client reroute based on workload

Client affinities

Version 9.8 or later

Version 9.1,
Version 9.5, or
Version 9.7 (before Fix Pack 1)

Connection-level workload balancing (transaction-level workload balancing is not available)

Automatic client reroute based on workload

Combinations of DB2 Version 9.1, DB2 Version 9.5, DB2 Version 9.7, and DB2 Version 10.1 clients and servers

Generally, DB2 Version 9.1, DB2 Version 9.5, and DB2 Version 9.7 clients can access a remote DB2 Version 10.1 server. However, if different versions of a client and a DB2 server are located on the same system, local client-to-server connections using Interprocess Communication (IPC) are not supported. Instead, you can establish a connection as a remote connection (called a loopback connection) by using TCP/IP.

The following clients and drivers can access a DB2 Version 9.7, DB2 Version 9.5 or DB2 Version 9.1 server:

IBM® Data Server Client Version 10.1
IBM Data Server Runtime Client Version 10.1
IBM Data Server Driver Package Version 10.1
IBM Data Server Driver for ODBC and CLI Version 10.1

However, when a later-level client accesses an earlier-level server, the functionality of the later level of the client is not available to the server. For example, IBM Data Server Driver Package Version 10.1 can access a DB2 Version 9.5 server; however, DB2 Version 10.1 functionality is not available to the server.

Note: 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.

Combinations of DB2 Version 10.1 and DB2 products on midrange and mainframe platforms

DB2 Version 10.1 servers support access from the following clients on midrange and mainframe platforms:

DB2 for z/OS® and OS/390® Version 8 or later
DB2 for i5/OS™ Version 5 or later
DB2 for VM and VSE Version 7

The following clients and drivers can access a DB2 Connect™ Version 9.7, Version 9.5 or Version 9.1 server:

IBM Data Server Client Version 10.1
IBM Data Server Runtime Client Version 10.1
IBM Data Server Driver Package Version 10.1
IBM Data Server Driver for ODBC and CLI Version 10.1

Note: DB2 Connect 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.