DB2 Connect Version 10.5 for Linux, UNIX, and Windows

Considerations for System z SYSPLEX exploitation

DB2 Connect™ provides load balancing and fault-tolerance when routing connections to DB2® Sysplex. When connected to a DB2 for z/OS® database server running in a DB2 pureScale® environment, DB2 Connect will spread the workload amongst the different DB2 subsystems comprising the data sharing group, based on the system load and health information provided by the Workload Manager (WLM). It uses the Distributor to route connections. Use the group IP address to connect to a group location.

DB2 Connect receives a prioritized list of DB2 members from the WLM. Each Sysplex returns weighted priority information for each connection address that has capacity to run the work. This list is then used by DB2 Connect to handle the incoming CONNECT requests by distributing them among the DB2 members with the best capacity to run work. For load balancing, the list of Sysplex weighted priority information is obtained during each connection. This list is also used when determining where to send each transaction.

Note: System z® Distributed Data Facility (DDF) configuration does not need to be changed to take advantage of the DB2 Connect Sysplex exploitation. Refer to DB2 for z/OS Data Sharing Planning and Administration guide.

DB2 Connect also provides fault-tolerance by attempting to connect to an alternate sysplex machine in the event of a connection failure. An error will only be returned to the application if all known connections have failed.

DB2 Connect is designed with a transport tool. With Sysplex enabled, DB2 Connect routes connections using a transport member and associates it with a logical connection.