FIX: Microsoft ADO.NET provider for DB2 fails to read data stored in DB2 for z/OS V11 BLOB and CLOB columns that are greater than 1,048,576 bytes

Symptoms

The Microsoft ADO.NET provider for DB2 fails to read data stored in DB2 for z/OS V11 BLOB and CLOB columns that are greater than 1,048,576 bytes.
In this case, you may get the following error message:

Not supported LOB data format. SQLSTATE HY000 with SQLCODE -343

Cause

The Microsoft ADO.NET Provider for DB2 and the underlying Microsoft DRDA Application Requester Client for DB2 do not process DB2 for z/OS V11 BLOB and CLOB data values that are longer than 1,048,576 bytes.

Status

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

Resolution

This issue is fixed in the following cumulative update for Host Integration Server:

• Cumulative Update 3 for Host Integration Server 2016

Note The Microsoft ADO.NET Provider for DB2 and the underlying Microsoft DRDA Application Requester Client for DB2 have been corrected to support data conversion for DB2 for z/OS V11 BLOB and CLOB data values that are longer than 1,048,576 bytes.

References

Learn about the terminology that Microsoft uses to describe software updates.