Chapter 14. Accessing Distributed Data

• Distributed data

• Coding methods for distributed data

• Programming considerations

• Remote query performance

The DB2 Distributed Data Facility (DDF) allows access to data held by other data management systems or makes your DB2 data accessible to other systems. A DB2 application program can use SQL to access data controlled by non-DB2 database management systems at which the application's plan is bound. This DB2 is known as the local DB2 or application requester (AR). Any DBMS that supports remote connectivity is called an application server (AS). Any application server other than the local DB2 is considered a remote server (RS), and access to its data is a distributed operation. DB2 provides two methods ...

Get DB2® for z/OS® Version 8 DBA 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.