Summary
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 looked at the two methods that DB2 provides 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.
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
