You can use the workbench to complete several important
tasks that help you estimate database size requirements.
In a typical scenario, you complete the following tasks to estimate
database size:
- Enter volumetrics information for
tables and columns in a physical data model, or for entities and attributes
in a logical data model. For physical data models that target DB2® for z/OS® databases, you can also add volumetrics
information for indexes.
- Transform these properties as needed during logical-to-physical data model transformation.
- During data model analysis, use these properties to ensure
that storage design for table spaces is consistent with projected
database size.
- Use these properties to update the design of a table space when
you apply a table space to a table or tables in a
physical data model.
- Generate reports for logical and physical data
models that communicate database size requirements to other team members.