Using the Create Utility

Close the Table Map Editor or select Update and Return from the File menu to display the Create dialog.

create dialog, showing names and status of objects to be created

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.