Index Defaults tab

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.

Example of the Index Defaults tab on the DB Alias Editor, described as follows.

Identifier

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

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, which is 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 - 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 to specify the tablespace for new indexes. You can create a new index that is based on the following options:

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 that is to be used when you create an index, such as BP1. 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 that were previously specified for this DB Alias, as well as <DEFAULT> and <SOURCE>.

<DEFAULT>
Select to use the default buffer pool that is specified by DB2 MVS. When you create an index, the Optim solution 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.


Feedback