Distributed database administration

 

DB2^® UDB for iSeries™ allows you to work with databases that are distributed across several systems.

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

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

• Security
  The i5/OS operating system has built-in security elements that limit access to the 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.

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

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

 

Parent topic:

Administration

 

Related concepts

Distributed database programming