Use the options on the Create tab to set defaults for creating objects. Note that 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, 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 apply 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 continuing.
This feature applies to Oracle compile errors that may occur on certain database objects: functions, packages, package bodies, procedures, triggers, and views. (The Create Process can create these objects, but they may not be functional.) Select this check box to correct possible problems in the Review SQL dialog before performing 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 (i.e., Create and DDL) to create and delete LOB tablespaces, AUX tables, and unique Indexes. When you clear this check box, DB2 OS/390® automatically creates and deletes LOB tablespaces, 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 shown on the Review SQL dialog before creating 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 tablespace (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 tablespace (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 tablespace (segment, filegroup, or dbspace) for creating tables. If you clear this check box, the Create Utility attempts to use the tablespace (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 to 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 zero (0), 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 tablespace (segment, filegroup, or dbspace) for creating indexes.
Specify the default identifier for new indexes based on the identifier from one of the following:
Enter a percent (0 to 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 zero (0), 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 tablespace (segment, filegroup, or dbspace) for creating new indexes, based on one of the following:
The buffer pool (e.g., BP1) that is to be used when creating an Index. You can 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 already specified for this DB Alias (i.e., on the Index Defaults tab of the DB Alias Editor), as well as 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 the default identifier for new aliases based on the identifier from one of the following:
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 the default identifier for new synonyms based on the identifier from one of the following:
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 the default identifier for new triggers based on the identifier from one of the following: