Before creating a database, you should consider the rules for building a flexible Agile architecture. A flexible architecture is one that grows with the organization without impacting availability, reliability, or performance. It should be easy to maintain and upgrade as new releases of Db2 are made available. Runtime Application Self-Protection (RASP) and Agile Database Implementation (ADI) follows Agile constructs in the definition and use of database objects.
You can read about both Optimal Flexible Architecture (OFA) and ADI at www.enterprisedb2.com.
The following list shows the different areas of physical database design that should be considered before transforming a physical data model into a physical database, based on application requirements:
- Database partition groups
- Block-based buffer pools
- Tablespace volumetrics
- Very large tables
- Indexes
- Aliases...