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 that are 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 needed, 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 applies 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 you can use 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.

Note: If the DBMS is PostgreSQL, all options on the Tables and Indexes tabs are disabled because you cannot create objects for PostgreSQL in Optim™ 11.3. In addition, the Synonyms and Triggers tabs are not displayed for PostgreSQL.

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™. Tablespace (or Segment, Filegroup, or DBSpace) is enabled for Oracle, DB2 UDB, DB2 MVS, Sybase ASE, SQL Server, or Informix® with the appropriate label.

Example of the Tables tab on the DBMS Defaults dialog, described as follows.
Database
For DB2 MVS only, the default database. 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 that is 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 table space that matches the source.

  • If the name of a target table space does not match the source name, tables and subordinate objects are created in a table space that is designated by the name value, if any, in Tablespace.
  • If the name of a target table space 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 - 999. The default value is 100. Specify 0 (zero) to use the target system default.

Indexes tab

Use the Indexes tab to provide defaults for creating database indexes.

Example of the Indexes tab on the DBMS Defaults dialog, described as follows.
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-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-999. The default value is 100. Specify 0 (zero) 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 table spaces for the target database or select <DEFAULT> to use the target system default.
Buffer Pool
For DB2 MVS only, the default buffer pool that is used to create an Index. You can type an explicit value (such as 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 that is specified for the DB Alias or as a Personal Option.

Aliases tab (DB2)

For DB2 UDB or DB2 MVS, use the Aliases tab to provide defaults for creating DB2 Aliases.

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-64 characters).

Synonyms tab (Oracle/Informix)

For Oracle or Informix, use the Synonyms tab to provide defaults for creating Synonyms.

Example of the Synonyms tab on the DBMS Defaults dialog, described as follows.
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-64 characters).

Triggers tab

For DB2 UDB, Oracle, Sybase ASE, SQL Server, or Informix, use the Triggers tab to provide defaults for creating Triggers.

Example of the Triggers tab on the DBMS Defaults dialog, described as follows.
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-64 characters).


Feedback