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.
Server version | Client version | Features available |
---|---|---|
Version 10.5 or later | Version 10.5, Version 10.1, or 9.7 Fix Pack 1 or later | Transaction-level and connection-level workload
balancing Automatic client reroute based on workload Client affinities |
Version 10.5 or later | 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 |
Generally, DB2 Version 9.5, DB2 Version 9.7, DB2 Version 10.1 clients can access a remote DB2 Version 10.5 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 10.1, Version 10.5, DB2 Version 9.7 or DB2 Version 9.5 server:
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.5 can access a DB2 Version 9.5 server. However, DB2 Version 10.5 functionality is not available to the server.
DB2 Version 10.5 servers support access from the following clients on midrange and mainframe platforms:
The following clients and drivers can access a DB2 Connect™ Version 10.1, Version 9.7, Version 9.5 server: