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.

How you code an application program, where it resides in relation to the data, and the network design that connects application programs to data are all important design considerations.

Database design in a distributed relational database is more critical than when dealing with just one iSeries™ relational database. With more than one iSeries server to consider, you must develop a consistent management strategy across the network. The following operations require particular attention when forming your strategy:

• General operations
• Networking protocol
• System security
• Accounting
• Problem analysis
• Backup and recovery processes

To prepare for a distributed relational database, you must understand both the needs of the business and relational database technology.

• Identify your needs and expectations for a distributed relational database
  Consider these items when analyzing your needs and expectations of a distributed relational database.
• Design the application, network, and data for a distributed relational database
  Designing a distributed relational database involves making choices about applications, network considerations, and data considerations.
• Develop a management strategy for a distributed relational database
  When you are managing a distributed relational database, keep these strategies in mind.