You cannot change the owning user ID.
You cannot change the name of the index.
You cannot change the user ID of the person who
owns the table for this index.
You cannot change the name of the table
for this index.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change the columns in the index key.
You cannot change this value when you alter an index.
You cannot change this value when you alter an index.
You cannot change this value when you alter an index.
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.
You cannot change this value when you alter an index.
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.