Using the Create utility

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.