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.