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.
Before you begin
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:
- In the Data Project Explorer, right-click a database object in a physical
data model, and click . From the sub menu, select a table space.
- Drag and drop an existing table space from a database connection in the
Data Source Explorer to the physical data model.
About this task
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
- Right-click a table space object in a physical data model from
the Data Project Explorer, and select Apply Table Space. A wizard opens.
- Complete the wizard steps.
- On the first page of the wizard, you can select a different table space
to use as a template.
- 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.
- Click Finish.
Results
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.