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
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
Procedure
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.