Data providers for DB2 are updated to support IBM Netezza and IDAA (IBM DB2 Analytics Accelerator)

Summary

The Data Providers for DB2 do not currently support specifying the SET CURRENT QUERY ACCELERATION special registers statement. This statement is required when you connect to the IBM Netezza data warehouse appliance or to the IDAA (IBM DB2 Analytics Accelerator).

To process the required SET CURRENT QUERY ACCELERATION special registers statement for DB2, the Microsoft DRDA Application Requester runtime library was updated to support the DRDA EXCSQLSET (Set SQL Environment) and SQLSTT (SQL Statement) protocol code points.

More Information

The Microsoft Data Provider for DB2 and related configuration tools are updated in this update to expose a new special registers connection property. 

Microsoft OLE DB Provider for DB2

When you specify a DB2 SET special register statement for OLE DB Provider for DB2, you should delimit the special registers argument by using double quotation marks around the value (Special Registers="SET CURRENT QUERY ACCELERATION=ALL").

For example, use the following:

[oledb]

; Everything after this line is an OLE DB initstring

Provider=DB2OLEDB.1;Network Transport Library=TCPIP;Network
Address=<value>;Network Port=446;User ID=<value>;Password=
<value>;Initial Catalog=<value>;Host CCSID=37;PC Code Page
=1252;Package Collection=NULLID;Special Registers="SET 
CURRENT QUERY ACCELERATION=ALL"

Microsoft ADO.NET Provider for DB2

When you specify a DB2 SET special register statement for use with the ADO.NET Provider for DB2, delimit the special registers argument by using single quotation marks around the value (Special Registers='SET CURRENT QUERY ACCELERATION=ALL').

For example, use the following:

[adonet]

string connString = "Network Address=<value>;Network 
Port=446;User ID=<value>;Password=<value>;Initial 
Catalog=<value>;Host CCSID=37;PC Code Page=1200;Package 
Collection=NULLID;Special Registers='SET CURRENT QUERY 
ACCELERATION=ALL'";

 

Resolution

The fix that resolves this problem is included in the following cumulative updates for Host Integration Server:

Cumulative Update 2 for Host Integration Server 2016

Cumulative Update 4 for Host Integration Server 2013

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.

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×