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'";