Distributed database programming

 

Distributed database programming describes the distributed relational database management portion of the i5/OS^® licensed program. Distributed relational database management provides applications with access to data that is external to the applications and typically located across a network of computers.

This information is intended primarily for application programmers responsible for the development, administration, and support of a distributed relational database on one or more System i™ products.

Application programmers who are not familiar with the i5/OS database can also get a view of the total range of database support provided by the i5/operating system (i5/OS). Application programmers can use this information to see the system context in which distributed relational database applications run.

Before using this information, you should be familiar with general programming concepts and terminology, and have a general understanding of the System i environment and the i5/OS operating system.

By using the code examples, you agree to the terms of the Code license and disclaimer information.

• What's new for V5R4
  This topic highlights the changes made to this topic collection for V5R4.

• Printable PDF
  Use this to view and print a PDF of this information.

• 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.

• Planning and design
  The first requirement for the successful operation of a distributed relational database is thorough planning. You must consider the needs and goals of your enterprise when making the decision to use a distributed relational database.

• Initial setup
  The i5/OS operating system provides runtime support for distributed relational databases. However, some setup work might be required to make the application requesters and application servers ready to send and receive work, particularly in the Advanced Program-to-Program Communication (APPC) environment.

• Security
  The i5/OS operating system has built in security elements that limit access to data resources of an application server. Security options range from simple physical security to full password security coupled with authorization to commands and data objects.

• Application development
  Programmers can write high-level language programs that use SQL statements for i5/OS distributed application programs.

• Administration
  As an administrator for a distributed relational database, you are responsible for work that is done on several systems.

• Data availability and protection
  In a distributed relational database environment, data availability involves not only protecting data on an individual system in the network, but also ensuring that users have access to the data across the network.

• Performance
  No matter what kind of application programs you are running on a system, performance can always be a concern. For a distributed relational database, network, system, and application performance are all crucial.

• Troubleshooting
  When a problem occurs accessing a distributed relational database, it is the job of the administrator to determine the nature of the problem and whether it is a problem with the application or a problem with the local or remote system.

• Examples: Application programming
  This example application for distributed relational database use is written in RPG/400^®, COBOL/400^®, Java™, and ILE C programming languages. This example shows how to use a distributed relational database for functional specification tasks.

• User FAQs
  You need to consider these conditions when working with another specific IBM product.

• Interpreting trace job and first-failure data capture data
  This additional problem-analysis information is useful to specialists responsible for problem determination. It is also for suppliers of software products designed to conform to the Distributed Relational Database Architecture who want to test connectivity to a System i platform.

• Related information for distributed database programming
  Listed here are the product manuals and IBM Redbooks™ (in PDF format), Web sites and information center topics that relate to the distributed database programming topic. You can view or print any of the PDFs.