Specify an integer that identifies the partition.
Select the Value column, type a constant value, and
press Enter. The value is used to determine the highest value of the key
in the corresponding partition of the index. For more information on the
VALUE setting, see CREATE INDEX in the SQL Reference.
Specifies that you want to manage data sets.
Specify the integrated catalog facility where
the data sets for this index are catalogued. If the catalog name is greater
than eight characters, then you must use an alias for this setting.
Specifies that DB2 manages data sets.
Opens a window where you can select from a list of objects.
Specify a storage group at the current server that
includes at least one volume serial number in its description.
Important: The privilege set must contain SYSADM authority,
SYSCTL authority, or USE privileges on the specified storage group.
Type the Minimum primary space allocation.
Specify an integer between 12 and 4194304, inclusive.
Enables DB2 to extend the data set for the index if necessary. Specify
an integer between 12 and 131068, inclusive. If you
specify 0, DB2 cannot extend the data set.
If you specify a Minimum primary space and do not specify this value,
then DB2 calculates a default secondary space allocation.
The default is the larger of two values:
(1) 10 percent of the minimum primary space allocation or (2) 3 times the
index page size, which is 3 * 4KB.
Specifies that the associated data sets are erased when you drop this index
Specifies that you want to explicitly manage free space in the index space
Specify values to define your explicit management of free space.
Type a value or use the buttons to increment displayed value.
Specify values to define your explicit management of free space.
Type a value or use the buttons to increment displayed value.
When more that one DB2 member has the index or partition open and at least
one member has the index open for an UPDATE operation, updated pages are
written to the group buffer pool.
Important: This setting is ignored and no pages are cached if the
group buffer pool is defined for cross-invalidation use only.
Pages are cached in the group buffer when read in from DASD.
Important: This setting is ignored and no pages are cached if the
group buffer pool is defined for cross-invalidation use only.
Submits the data in the window and keep the window open for further input.
Available only when the required fields are completed.
Closes this window.