Specifying optional properties
These steps are part of the larger task of
Altering a nonpartitioned index. When you
complete the steps for modifying the index
properties, return to Altering an Index.
To specify optional properties:
-
In the Buffer pool field specify a different buffer pool for
your index. You must specify an active
4
KB buffer pool. The default buffer pool
is
the database's buffer pool, unless the
database
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
- In the Maximum data set size field, type or select a new value for the
maximum addressability of each piece (data
set) for a nonpartitioning index (PIECESIZE).
The integer value is multiplied by 1 024
to specify the maximum piece size in bytes.
The integer must be a power of two between
256 and 67 108 864.
- Select the Close eligible data sets check box if you want DB2 to close data
sets when the index is not being used or
when the limit on the number of open data
sets is reached. If you select the Close eligible data sets check box, then, 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 with No. If the limit is reached, and there are
indexes with the close eligible data
sets
setting, then DB2 closes indexes without the close
eligible data sets setting.
- Select the Allow COPY utility for the index check box to allow full image or concurrent
copies on the index and to allow a recovery
of the index. Select Copy, Concurrent Copy
or Recover from the contents pane popup
menu,
to execute these utilities. .
[Return to Alter an index]