Summary

Team-Fly

---

 

	DB2 Universal Database for OS/390 v7.1 Application Certification Guide By Susan Lawson
	Table of Contents
	Chapter 10.  Accessing Distributed Data

---

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.

---

Team-Fly

Top