The DB2 data providers that are included in Microsoft Host Integration Server 2010 cannot connect to a replicated IBM DB2 database when the initial TCP/IP connection to the IBM DB2 database fails.
This problem occurs because the TCP/IP connection that the DB2 data provider uses does not return an error message when the TCP/IP connection fails. Additionally, the workload-balancing feature that is implemented by the DB2 data providers cannot connect to any of the other IBM DB2 systems that are returned in the Server List (SRVLST) parameter of the Access RDB (ACCRDB) distributed data management (DDM) command.
The hotfix that resolves this issue is included in cumulative update package 3 for Host Integration Server 2010.
For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2654652 Cumulative update package 3 for Host Integration Server 2010
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.