Use the options on the Create tab to set defaults for creating objects. 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, as described in the following text, 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 options on the Create tab to set second-level defaults for the Create utility.

Specify the DB Alias that identifies the database in which you want to create database objects. To select from a list, click the down arrow. Specify default options for creating different types of database objects on each corresponding tab.
Select this check box to automatically drop any Oracle object that causes a compile error during the Create Process. If you clear this check box and compile errors occur, you must interrupt the Create Process to drop the object before you continue.
This feature applies to Oracle compile errors that might occur on certain database objects: functions, packages, package bodies, procedures, triggers, and views. (The Create Process can create these objects, but they might not be functional.) Select this check box to correct possible problems in the Review SQL dialog before you do the Create Process.
Select this check box to replace table-type column references to User Defined [data] Types with base column data types in any generated DDL. When you clear this check box, references to UDTs are preserved in generated DDL. (This check box is available only when you select a DB Alias for a DB2®, Sybase ASE, or SQL Server database.)
Select this check box to require the user to create and delete LOB table spaces, AUX tables, and unique Indexes. When you clear this check box, DB2 OS/390® automatically creates and deletes LOB table spaces, AUX tables, and unique Indexes. This check box is selected by default.
Select a font color to highlight object name changes in the SQL statements that are shown on the Review SQL dialog before you create those objects in the target database. During the Create Process, object names (specified in the Table Map) are translated to be appropriate for the target database. This feature applies to creating text type database objects: functions, packages, package bodies, procedures, triggers, and views.
Use the Tables tab to specify the default database (for DB2 MVS™). Specify a default table space (segment, filegroup, or dbspace) for creating database objects. Specify an allocation percent to adjust SQL storage-related parameters (for Oracle and DB2 MVS).
Enter the name of the default database for creating tables. To select from a list, click the down arrow. This option is available only if you are using DB2 MVS. A single DB Alias in Optim can identify more than one database in DB2 MVS.
Select this check box to use the default database for creating tables. If you clear this check box, the Create Utility attempts to use the source database from the Source File. However, if the source database does not exist on the target system, the Create Utility uses the default database.
Enter the name of the default table space (segment, filegroup, or dbspace) for creating tables. To select from a list, click the down arrow. If you select <Default>, the default set in the database is used.
Select this check box to use the default table space (segment, filegroup, or dbspace) for creating tables. If you clear this check box, the Create Utility attempts to use the table space (segment, filegroup, or dbspace) in the Source File. However, if the source does not exist on the target system, the Create Utility uses the default.
Enter a percent (0 - 999) to adjust SQL storage-related parameters for the Create Utility. The default is 100. Allocation percent is available for creating tables and indexes in Oracle and creating indexes in DB2 MVS.
Target SQL is generated based on the values of the objects in a Source File. If you specify 0 (zero), the storage-related clause in the SQL statement is omitted. Using a value other than zero results in a percentage of the source value being used in the target clause.
Use the Indexes tab to select a default identifier for creating new indexes. Specify an allocation percent to adjust SQL storage-related parameters (for Oracle and DB2 MVS). Specify the default table space (segment, filegroup, or dbspace) for creating indexes.

Specify a default identifier for new indexes that is based on one of the following identifiers:
Enter a percent (0 - 999) to adjust SQL storage-related parameters for the Create Utility. The default is 100. Allocation percent is available for creating tables and indexes in Oracle and creating indexes in DB2 MVS.
Target SQL is generated based on the values of the objects in a Source File. If you specify 0 (zero), the storage-related clause in the SQL statement is omitted. Using any value, other than zero, results in a percentage of the source value being used in the target clause.
Specify a default table space (segment, filegroup, or dbspace) for creating new indexes that is based on one of the following entries:
The buffer pool, such as BP1, that is to be used when you are creating an Index. Enter a specific value for the buffer pool or select a value from the list. Buffer Pool is displayed only for DB2 MVS.
The list displays any index buffer pools that are already specified for this DB Alias (on the Index Defaults tab of the DB Alias Editor), along with the following:
Use the Aliases tab to select default options for creating new aliases. You can specify a default alias when you use DB2 CS, DB2 UDB, or DB2 MVS.

Specify a default identifier for new aliases that is based on one of the following identifiers:
Use the Synonyms tab to select default options for creating new synonyms. You can specify a default synonym when you use Oracle or Informix®.

Specify a default identifier for new synonyms that is based on one of the following identifiers:
Use the Triggers tab to select default options for creating new triggers. You can specify a default trigger when you use DB2 UDB, Oracle, Sybase ASE, SQL Server, or Informix.

Specify a default identifier for new triggers that is based on one of the following identifiers: