Specifying optional properties

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

1. In the Number of subpages for each physical page field, if you selected to create a type 1 index, specify a number indicating the unit of index locking that DB2 uses for each physical page. Type 1, 2, 4, 8, or 16. In a data sharing environment you must specify 1. If you selected index type 2, this field is not available.
   
   
2. 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.
   
   
3. In the Data set password field, type the password for the VSAM data sets. This password is defined through access method services. If you use storage groups, this password is the password that protects the data as well as the password that is passed to access method services when DB2 uses the data sets. If the index occupies multiple data sets, these data sets must have the same password.

   Important: The password setting does not apply to data sets that are managed by the Storage Management Subsystem (SMS). RACF or a similar external security system protects data sets defined to SMS.
   
   

4. Select 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. If you selected Cluster by index values, this field is unavailable.
   
   
5. Select the Close eligible data sets check box. This value sets the priority for determining which data sets DB2 should close. Select the 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.
   
   

[Return to Alter an index]