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:
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.