Defaults Dialog

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.

dbms defaults tables tab, explained below
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.

dbms defaults indexes tab, explained below
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).

dbms defaults synonyms tab, explained below
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).

dbms defaults triggers tab, explained below
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).