Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Resolution

This issue is fixed in Cumulative Update 1 for Host Integration Server 2016.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

Learn about the terminology Microsoft uses to describe software updates.

Third-party information disclaimer

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.

 

↑ Back to the top

Keywords: kbQFE, kbfix, kbBug, kbExpertiseInter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 4010358
Revision : 17
Created on : 5/24/2017
Published on : 5/24/2017
Exists online : False
Views : 170