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 using 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 previously 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 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 referenced
in the Table Map. The utility identifies objects that already 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 unselect all objects 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 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 may require research or analysis to determine the
appropriate action.
- Created
- Object was created earlier and can be dropped.
- Exists
- Object existed prior to 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
has been created. For example, a foreign key (FK) is not created until
both tables in the relationship are created.
- Unsupported
- Object 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 (e.g., tables).
To modify names of tables and certain other objects (e.g., Defaults,
Rules, 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 to 999. Specify
a value to override defaults for an object or zero (0) to use the
target system default. (See Defaults Dialog for
additional information regarding defaults.)
- 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, identified as <DEFAULT>,
unless overridden by a tablespace name provided on:
- The Table Defaults tab of
the DB Alias editor (see Table Defaults),
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 accessed
from the Defaults menu of the Create dialog.
See Defaults Dialog for details.
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 will fail.
- 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.