Index Defaults

The Index Defaults tab displays the index defaults associated with a DB Alias. The default index varies depending on the database management system for which the DB Alias is defined.

db alias editor index defaults tab, explained below

Identifier

Select default options used to specify the identifier for new indexes. You can create a new index based on the following:

Table
Identifier from the target table.
Source
Identifier from the source index.
Current ID
Current database user ID from a destination.
Explicit
New identifier. If you select this option, you must specify an identifier.

Allocation Percent

Allocation Percent, required for Oracle and DB2® MVS™ only, allows the adjustment of storage-related parameters on Create and Alter statements for indexes. The allowable range is 0 to 999. The default value is 100.

Default Tablespace

Default Tablespace (segment, filegroup, or Dbspace) is required for Oracle, Sybase ASE, Informix® and SQL Server. Select default options used to specify the tablespace for new indexes. You can create a new index based on the following:

Table
Same tablespace as the owning table.
Source
Same tablespace as the index in the Extract File (if possible).
Explicit
Select the tablespace from the list of available tablespaces for the database. Select <DEFAULT> to eliminate any tablespace from the Create Index SQL statement and cause the index to be created in the default tablespace.

Buffer Pool

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. A Buffer Pool value is required for DB2 MVS only.

The list displays any index buffer pools previously specified for this DB Alias, as well as <DEFAULT> and <SOURCE>.

<DEFAULT>
Select to use the default buffer pool specified by DB2 MVS. When creating an index, Optim does not generate a BUFFERPOOL clause in the Create statement.
<SOURCE>
Select to use the same buffer pool as the index of the source Archive or Extract File.