Close the Table Map Editor or select Update
and Return from the File menu to
display the Create dialog.
Server Name
The
location of the source file.
Source File
The
name and path for the source file.
Table Map
The name
of the Table Map or (Local). To create objects with a different source
file or Table Map, select Respecify Options from
the Tools menu to redisplay the Create
Options dialog. You can then provide a different source
file or Table Map name.
To change the names of
the tables or to process tables that were removed from the Table Map,
open the Table Map Editor by selecting Edit Table Map from
the Tools menu.
Tabs
The Create dialog
provides a tab for each DB Alias that is referenced by the Table Map.
The objects are listed on the appropriate tab. Each table name, followed
by the names of associated objects, is listed in the order that is
referenced in the Table Map. The utility identifies objects that exist
at the destination and assigns an appropriate status.
Object List
- Select
- Include
the object in Create or Drop processing or display in the Browse
SQL dialog. An object that does not exist at the destination
is selected automatically. Clear the check box to exclude an object,
as required.
To select or clear all objects that
are listed on the tab, select Select All Objects or Deselect
All Objects from the Tools menu
or the shortcut menu.
- Status
- The status
of the object, as follows:
- blank
- Object does not exist in the destination database
and can be created.
- Conflict
- Source
and destination conflict. A message describes the conflict, which
must be resolved before the object can be created. In some cases,
the object exists but does not match the attributes in the source
file (for example, a column precision mismatch).
The
method that is used to resolve a conflict varies by type of conflict.
For example, if the name of an object matches that of an object in
the target database, you can drop the object in the target or rename
the object to be created. However, a column mismatch for a primary
key or relationship might require research or analysis to determine
the appropriate action.
- Created
- Object was created earlier and can be dropped.
- Exists
- Object existed before opening the Create dialog
and can be dropped.
- Invalid Name
- Object name in the Create dialog
was modified and the modified value is invalid.
- Not Needed
- Object is created implicitly.
- Pending
- The object can be created after a prerequisite object
is created. For example, a foreign key (FK) is not created until both
tables in the relationship are created.
- Unsupported
- Object is not supported in the database.
To update the status of listed objects, select Refresh
Status from the Tools menu. For example, if
you change the setting for DB2® OS/390
Current Rules in Personal Options while the Create dialog is displayed,
you can Refresh Status to reflect the new setting. For more information,
see Create tab.
- Object Type
- The type of object definition as:
| Alias |
PK (DBMS) |
| Aux Table |
PK (Optim™) |
| Default |
Private Synonym |
| Ext Rel |
Rule |
| FK |
Rel |
| Function |
Synonym |
| Index |
Sequence |
| Package |
Trigger |
| Package Body |
Table |
| Procedure |
LOB Tablespace |
| User Defined Type (Datatype) |
View |
Note: DDL
objects are indented beneath each owning, parent, or superior object.
- Object Name
- Name of the object. You can modify the names of
most objects, except those mapped in the Table Map. To modify names
of tables and certain other objects (such as Defaults, Rules, and
UDTs), you must open the Table Map Editor.
- Alloc Perc
- Percentage by which storage-related SQL parameters
for the source object are adjusted (for Oracle and DB2 MVS™). The allowable range is 0 - 999. Specify
a value to override defaults for an object or 0 (zero) to use the
target system default. For more information about defaults, see Defaults dialog.
- Tablespace
- Name of the Tablespace, Segment, Filegroup, or DBSpace
for certain objects. The utility populates Tablespace when the Create dialog
opens. If an object exists at the target, the tablespace name is displayed
and cannot be modified. If the object does not exist, the initial
value is
- The name of the tablespace for the
source table, if it matches a target tablespace.
- The target system default, which
is identified as <DEFAULT>, unless overridden by a tablespace
name that is provided on:
- The Table Defaults tab
of the DB Alias editor (see Table Defaults tab),
unless overridden by a Personal Options setting.
- The Create tab
of Personal options (see Create tab), unless overridden by a Defaults dialog
setting.
- The Defaults dialog
that is accessed from the Defaults menu of
the Create dialog. For more information, see Defaults dialog.
To change the setting, click a Tablespace grid
cell and select:
- <DEFAULT>
- Use the target system default.
- <SOURCE>
- Use the source.
- name
- Use the designated tablespace.
Note: If you change a Tablespace value to <SOURCE>
and the source tablespace does not exist at the target, the Create
Process fails.
- Tablespace/Buffer pool
- For DB2 MVS, the label
is Tablespace/Buffer pool, rather than Tablespace.
- If the object is a table, this value
is the tablespace name. If the table exists, the tablespace name is
displayed and cannot be modified. If the table does not exist, the
initial value is provided as described for Tablespace and
can be modified in the same way.
- If
the object is an index, this value indicates the buffer pool for the
index. If the index exists, the buffer pool name is displayed and
cannot be modified. If the index does not exist, the initial value
is provided as described for Tablespace and
can be modified by clicking the grid and selecting from the list.