Altering an index

Authorities and privileges

To alter a partitioned index:

1. Open the Alter Index window.
   
   
2. The information on the Index page is read-only. It describes the index that is currently being altered. You cannot alter the index name, index owner, or other properties listed on this page.
   
   
3. Specify new values for the optional properties in the Properties page.
   
   
4. Specify new values for storage allocation and space management in the Index Space Management page. The information at the global, or index level, applies to the index and every partition, excluding any partitions selected on the Partition Management page.
   
   
5. From the Partition Management page, select a partition in the Data management at partition level table to change storage allocation and space management values for that partition.
   
   1. Click the Change push button to modify the values. The information changed at the partition level applies only to that partition, and overrides space management information defined at the index level.
      
      
6. Click OK to change the index description. The change to the description of the index takes effect the next time the data sets of the index space are opened.
   

• Creating an index
• Stopping indexes
• Starting indexes