Introduction to distributed database programming

 

i5/OS^® distributed relational database support consists of an implementation of IBM^® Distributed Relational Database Architecture™ (DRDA^®) and integration of other SQL clients through Application Requester Driver (ARD) programs.

i5/OS and the DB2 Universal Database™ for iSeries™ Query Manager and SQL Development Kit combine to provide this support.

This topic describes distributed relational database and how it is used on the i5/OS operating system.

In addition, an example distributed relational database called Spiffy Corporation is described. This fictional company uses the System i™ product in a distributed relational database application program. This sample of the Spiffy Corporation forms the background for all examples used in this topic.

• Distributed relational database processing
  A relational database is a set of data stored in one or more tables in a computer.

• Distributed Relational Database Architecture support
  Distributed Relational Database Architecture (DRDA) support for distributed relational database processing is used by IBM relational database products. DRDA support defines protocols for communication between an application program and a remote relational database.

• DRDA and CDRA support
  A distributed relational database might not only span different types of computers, but those computers might be in different countries or regions.

• Application requester driver programs
  An application requester driver (ARD) program is a type of exit program that enables SQL applications to access data managed by a database management system other than DB2 Universal Database for iSeries.

• Distributed relational database on i5/OS
  DB2 Universal Database for i5/OS provides all the database management functions for i5/OS. Distributed relational database support on the system is an integral part of the operating system, just as is support for communications, work management, security functions and other functions.

• Managing an i5/OS distributed relational database
  Managing a distributed relational database on the i5/OS operating system requires broad knowledge of i5/OS resources and tools.

• Example: Spiffy Corporation distributed relational database
  The Spiffy Corporation is used in several IBM manuals to describe distributed relational database support. In this topic collection, this fictional company has been changed somewhat to illustrate i5/OS support for DRDA in a network of System i products.

 

Parent topic:

Distributed database programming