Specify a database for the index.
Opens a window where you can select from list of objects
Specify a user ID of the person who will
own the index.
Opens a window where you can select from list of objects
Opens a window where you can select from list of objects
Opens a window where you can select from list of objects
Opens a window where you can select from list of objects
Specify a name for the index. Do not use the
name of an existing index at the current server. If you type more than
eight characters, only the first eight are used in the name.
Specify the user ID of the person who
owns the table on which you are creating an index.
Specify the name of the table on
which you are creating an index. (Use the unqualified identifier for the
table.)
Select the column or columns
that you want to define as part of the index key.
Displays the column or columns selected as part of the index key.
Moves the highlighted column or columns to the Selected columns list box.
Moves all columns to the Selected columns list box.
Moves the highlighted column or columns to the Available columns list box.
Moves all columns to the Available columns list box.
Changes the order of items in the Selected columns list box. The order in which
the columns appear in the Selected columns list box is the order
in which the index is created.
Changes the order of items in the Selected columns list box. The order in which
the columns appear in the Selected columns list box is the order
in which the index is created.
Optional: Use the Ascending and Descending radio buttons
to specify the search order for each index key.
Optional: Use the Ascending and Descending radio buttons
to specify the search order for each index key.
Optional: Select the Unique check box to ensure that two or more
rows of the index key do not contain data with the same value. If you select
the Unique check box, the Do not apply uniqueness constraint
to null valued key check box is available.
If you have data that needs to be viewed as a group or in sequence, select
the Cluster by index values check box. Do not select the Cluster
by index values check box if an existing index on the table already
uses it.
Recommendation: If your table is populated and the index is
nonunique, then you should defer the index build. If your table is populated
and the index is unique, however, you should not select the Build index
later check box. If you defer building the index, you can build it later using
the recover index utility.
Specify an active 4 KB buffer pool. The default buffer pool is
the database's buffer pool, unless the uses a 32 KB buffer pool. If the
index cannot use the database's buffer pool by default, then BP0 is used.
Important: The privilege set must contain SYSADM authority,
SYSCTL authority, or USE privileges on the specified buffer pool.
Select the maximum data set size for nonpartitioned indexes. If you selected
Cluster by index values, this field is unavailable.
Enables the index to be copied for use with the RECOVER utility.
Specify whether, when the conditions are met, DB2 will close the data sets for the least
recently used index spaces before it closes the data sets for index spaces
that are defined without the Close eligible data sets setting.
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.
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.
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.
Pages are not cached in the group buffer.
Opens the Add partition management window
Opens the Change partition management window.
Available if an entry is defined and selected
Removes the selected entry from the Data management at partition level table
Displays the defined partition management settings
Submits the data in the window and closes the window.
Displays the SQL statements that would be generated by your choices in this window.
Cancels the start process and closes this window.