FIX: The ADO.NET Provider for DB2 can't read data stored in DB2 for z/OS V11 TIMESTAMP(6) WITH TIME ZONE columns

Applies to: Host Integration Server 2016

Symptoms


Consider the following scenario:

  • You try to use a query to read data by using the Microsoft ADO.NET Provider for DB2.
  • The data is stored in DB2 for z/OS V11 as TIMESTAMP(6) WITH TIME ZONE.

When you run the query in this scenario, you experience the following exception:

More information


After this update is installed, the Microsoft DRDA Application Requester Client for DB2 data conversion functionality is updated to correctly process DB2 for z/OS V11 TIMESTAMP(6) WITH TIME ZONE columns.

Resolution


This issue is fixed in Cumulative Update 2 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.