Applying table spaces to tables in a physical data model with a wizard

With a wizard, you can create new table spaces for multiple tables with the same properties as a template table space in a physical data model. You can also apply a single table space to multiple tables. Use the wizard instead of the Data Project Explorer, the Properties view, or a physical data model diagram to save time when you work with large physical data models that contain many tables.
Prerequisite: You must create one table space to use as a template. You can create a new table space in a physical data model by using one of the following methods:
Restriction: The Apply Table Space wizard is only supported for physical data models that target the following databases:
  • DB2® database for Linux®, UNIX®, and Windows®
  • DB2 database for z/OS®
  • Oracle

To apply table spaces to tables in a physical data model by using a wizard

  1. Right-click a table space object in a physical data model from the Data Project Explorer, and select Apply Table Space. A wizard opens.
  2. Complete the wizard steps.
    1. On the first page of the wizard, you can select a different table space to use as a template.
    2. On the second page of the wizard, you select tables and specify options for applying the table space. The tables in the list include MQTs if your data model targets DB2 for Linux, UNIX, and Windows, and materialized views if your data model targets Oracle.
  3. Click Finish.
Depending on your specifications in the wizard, one of the following actions is applied by the wizard:
  • The template table space is applied to the tables that you specify.
  • New table spaces are created for each table with the same properties as the template table space. The table spaces are named based on the following information
    • If you specified a prefix in the Table Space Prefix field, the new table spaces are named based on the prefix, with a numeric identifier appended.
    • If you did not specify a prefix in the Table Space Prefix field, the new table spaces are named based on the first three characters of the name of the table that you applied them to, with an appended numeric identifier.

You can view the new objects or properties in the Data Project Explorer or in the Properties view.


Feedback