Symptoms
Assume that you run the IBM DB2 Analytics Accelerator for IBM z/OS (IDAA) to get complex analytic information from your DB2-for-z/OS environment. When you run a Select Count (*) statement by using the Microsoft Managed Provider for DB2, which is installed along with Host Integration Server 2016, you receive incorrect results.
Cause
This issue occurs because IBM DB2 Analytics Accelerator for IBM z/OS (IDAA) requires support for the following DRDA (Distributed Relational Databased Access) Codepoints in the OPENQRY (OpenQuery) DRDA Protocol Flow:
-
MGRLVLOVR
-
TYPDEFNAM
-
TYPDEFOVR
These Codepoints were not implemented in the "release" version of Host Integration Server 2016.
Resolution
This issue is fixed in Cumulative Update 1 for Host Integration Server 2016.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology Microsoft uses to describe software updates.
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.
