You can establish as many as three layers of default settings
for the creation of database objects, in addition to target system
defaults. The default settings determine the values displayed in the
Object List for the Create Utility and can be overridden at the object
level by editing the list.
At the broadest level, DB Alias settings
establish defaults for creating objects in the associated database.
If desired, you can provide Personal Options settings for a user or
group of users that override some or all DB Alias settings. A third
level of optional defaults apply at the processing level to override
Personal Options and DB Alias settings. Use the Defaults dialog
to establish this level of default settings for creating objects.
To open a Defaults dialog, select the DB Alias
name from the Defaults menu on the Create dialog.
The Defaults dialog provides tabs
that allow you to define defaults by object type. The display of tabs
and options on the Defaults dialog varies according
to the DBMS associated with the selected DB Alias. When you close
the dialog, the utility validates any settings and, if indicated,
resets values in the Create dialog.
Tables Tab
Use
the Tables tab to provide defaults for creating
database tables and subordinate objects. Database is
enabled for a DB Alias associated with DB2® MVS™, while Tablespace (or Segment, Filegroup,
or DBSpace) is enabled for Oracle, DB2 UDB, DB2 MVS, Sybase ASE, SQL Server, or Informix® with the appropriate label.

- Database
- The default database (for DB2 MVS only). Click the down arrow to select:
- <DEFAULT>
- Use the default database for the target system.
- <SOURCE>
- Use the source database.
- databasename
- Use the designated database.
- Use default database
- Select Use default database to
enable the Database setting.
Clear
the Use default database check box to ignore
the Database setting and create tables and
subordinate objects in the target database that matches the source.
- If the name of a target database does not match
the source name, tables and subordinate objects are created in a database
designated by the databasename value, if any, in Database.
- If the name of a target database does not match
the source name or databasename value in Database,
the target system default applies.
- Tablespace
- The default Tablespace, Segment, Filegroup, or DBSpace
(the label is appropriate to the DBMS). Click the down arrow to select:
- <DEFAULT>
- Use the target system default.
- <SOURCE>
- Use the source.
- name
- Use the designated Tablespace, Segment, Filegroup,
or DBSpace.
- Use default tablespace
- Select Use default tablespace to
enable the Tablespace setting.
Clear Use
default tablespace to ignore the Tablespace setting
and create tables in the target tablespace that matches the source.
- If the name of a target tablespace does not match
the source name, tables and subordinate objects are created in a tablespace
designated by the name value, if any, in Tablespace.
- If the name of a target tablespace does
not match the source name or name value in Tablespace,
the target system default applies.
- Allocation Percent
- 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. The default
value is 100. Specify zero (0) to use the target system default.
Indexes Tab
Use
the Indexes tab to provide defaults for creating
database indexes.

- Identifier
- The default Identifier for new indexes. This value
is used to assign a unique name to the index at the destination and
provides a convenient way to group and identify indexes. Select:
- Table
- Use the source table.
- Source
- Use the Identifier for the source index.
- Current ID
- Use the current DBMS user ID for the destination
index.
- Explicit
- Use an explicit Identifier (1 to 64 characters).
Type the identifier in the associated box.
- Allocation
- 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. The default
value is 100. Specify zero (0), to use the target system default.
- Default Tablespace
- A Tablespace, Segment, or FileGroup
(the label is appropriate to the DBMS) is required for Oracle, Sybase
ASE, or SQL Server indexes. Select:
- Table
- Use the Tablespace, Segment, or FileGroup for the
source table.
- Source
- Use the Tablespace, Segment, or FileGroup for the
source index.
- Explicit
- Use an explicit Tablespace, Segment, or FileGroup.
Click the down arrow to select from a list of tablespaces for the
target database or select <DEFAULT> to use
the target system default.
- Buffer Pool
- The
default Buffer Pool (for DB2 MVS only) used
to create an Index. You can type an explicit value (e.g., BP1) or
click the down arrow to select:
- <DEFAULT>
- The target system default buffer pool.
- <SOURCE>
- The buffer pool for the source index.
- bpname
- An index buffer pool specified for the DB Alias
or as a Personal Option.
Aliases Tab (DB2)
Use the Aliases tab
to provide defaults for creating DB2 Aliases
(for DB2 UDB, or DB2 MVS).
- Identifier
- The default Identifier for new aliases. This value
is used to assign a unique name to the alias at the destination and
provides a convenient way to group and identify aliases. Select:
- Object
- Use the identifier for the underlying source object.
- Source
- Use the identifier for the source alias.
- Current ID
- Use the current DBMS user ID for the target alias.
- Explicit
- Use an explicit Identifier. Type the identifier
to be used (1 to 64 characters).
Synonyms Tab (Oracle/Informix)
Use the Synonyms tab to provide
defaults for creating Synonyms (for Oracle or Informix).
- Identifier
- The default Identifier for new synonyms. This value
is used to assign a unique name to the synonym at the destination
and provides a convenient way to group and identify synonyms. Select:
- Object
- Use the Identifier for the underlying source object.
- Source
- Use the Identifier for the source synonym.
- Current ID
- Use the current DBMS user ID for the target synonym.
- Explicit
- Use an explicit Identifier. Type the identifier
to be used (1 to 64 characters).
Triggers Tab
Use
the Triggers tab to provide defaults for creating
Triggers (for DB2 UDB, Oracle,
Sybase ASE, SQL Server, or Informix).
- Identifier
- The default Identifier for new triggers. This value
is used to assign a unique name to the trigger at the destination
and provides a convenient way to group and identify triggers. Select:
- Object
- Use the Creator ID for the owning source object.
- Source
- Use the Creator ID for the source trigger.
- Current ID
- Use the current DBMS user ID for the target trigger.
- Explicit
- Use an explicit Identifier. Type the identifier
to be used (1 to 64 characters).