Specifying index space management

These steps are part of the larger task of Altering a partitioned index. When you complete the steps for modifying the index space management, return to Altering an Index.

To specify index space management:

1. Select the Data set management check box to define how your data sets are managed.
   
   
   1. Select the Managed by user or the Managed by DB2 radio button. If you select Managed by user, type or select a VSAM Catalog name. The name specifies 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. If you select Managed by DB2
      
      
      1. Specify a Storage group name. The storage group must be defined at the current server and it must include 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.
         
         
      2. Type the Minimum primary space allocation. This value should be an integer between 12 and 4194304, inclusive. Smaller or larger values will use 12 or 4194304, respectively.
         
         
      3. Type the Minimum Secondary space allocation. If you want DB2 enabled to extend the data set for the index if necessary, this value should be 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 * 4 KB.
         
         
      4. Select the Erase data sets when the index is dropped check box to erase data sets for the index or partition when they are deleted during the execution of a utility or when you drop the index. The index or partition must be in the stopped state when you are altering the index.
         
         
2. Select the Specify management scheme for free space to determine how to manage free space on pages.
   
   
   1. In the Free space reserved field, select an integer value from 0 to 255 that describes how often to leave a page of free space when index entries are created as the result of executing a DB2 utility. One free page is left for every integer pages.
      
      
   2. In the Percentage of free space in a page field, select an integer value from 0 to 99 to determine the percentage of free space to leave in each nonleaf page and leaf page when entries are added to the index or partition as the result of executing a DB2 utility. The first entry is loaded without restriction. When additional entries are placed in a nonleaf or leaf page, the percentage of free space is at least as great as integer.
      
      
3. Select the Cache pages in a group buffer pool check box to specify what index pages are written to the group buffer pool in a data sharing environment. Select one of the following radio buttons:
   
   
   1. Only on update (CHANGED) When more than 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.
      
      
   2. Always cache pages (ALL) Pages are cached in the group buffer when read in from DASD.
      
      
   3. No caching (NONE) No pages are cached to the group buffer pool.
      
      

[Return to Alter an index]