Specifying optional properties

These steps are part of the larger task of Creating an index. When you complete the steps for specifying the index properties, return to Creating an Index.

1. In the Buffer pool field specify a buffer pool for your index. You must specify an active 4 KB buffer pool. The default buffer pool is the database's 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
   
   
2. Specify the maximum data set size, or PIECESIZE, for nonpartitioned indexes. This should be an integer that will be multiplied by 1024 to result in the number of bytes. The choices are integers that are powers of two between 256 and 4194304.
   The Maximum data set size field is not applicable for a partitioned index.
   
   
3. 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.
   
   
4. 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 Create an index]