FIX: Bad results when you run a Select Count(*) statement against DB2 with IDAA

Applies to: Host Integration Server 2016

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.