The Microsoft OLE DB Provider for DB2 (Data Provider) connects Microsoft SQL Server database applications to remote IBM DB2 relational database management servers, for on-line transaction processing, analysis and reporting. The Data Provider functions as a DB2 application requester client supporting the standard distributed relational database architecture (DRDA) protocols and formats that are compatible with IBM DB2 server products functioning as DB2 application servers.

The Data Provider enables interoperability between DB2 client applications and DB2 server databases by issuing structured query language statements. These include data definition language statements for administration and data manipulation management statements for read and write operations. The Data Provider connects the DB2 client applications to the DB2 server databases across a transmission control protocol over internet protocol (TCP/IP) network that uses the optional security features described in this topic.

User Account

The Data Provider, Data Access Tool and Data Links, run in the context of a user account for the SQL Server 2014 OLE DB consumer program, such as the SQL Server Data Tools (SSDT) or the SQL Server Management Studio.

Folder Access Control List

The user account requires the Folder Access Control List settings to for these folders.

File Folder Modify Read & execute List folder contents Read Write Special permissions
Program Files\Microsoft OLE DB Provider for DB2 Allow Allow Allow
Program Files\Microsoft OLE DB Provider for DB2\system Allow Allow Allow
Program Files\Microsoft OLE DB Provider for DB2\ SysWOW64 Allow Allow Allow
Program Files\Microsoft OLE DB Provider for DB2\traces Allow Allow Allow Allow
Documents\Host Integration Server\Data Sources Allow Allow Allow Allow