Access to DB2 from remote locations is a necessary part of most application environments. DB2 provides that capability through various means. Using the Distributed Data Facility (DDF) of DB2 allows for access to data held by other DBMSs or makes your DB2 data accessible to other systems. A DB2 application program can use SQL to access data at DBMSs other than the DB2 at which the application's plan is bound.
We saw that DB2 provides two methods for accessing data at remote application servers: DRDA and DB2 private-protocol access. We also looked at the use of three-part names and the DB2 CONNECT statement. Last, we covered some of the ways to improve performance of remote queries.