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.
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.
- By default, the target SQL is created
using the values for the source objects in the Extract 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.
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.