Changing partition management

Use the Change partition management window to alter properties for managing storage at the partition level. These steps are part of the larger task of altering a table space. When you complete the steps for changing partition management, return to the Alter Table Space window.

To change partition management:

1. The Partition field shows you the current partition for which you are modifying parameters.
   
   
2. Select Managed by user or Managed by DB2 from the Data Set Management radio buttons.
   
   
3. If you selected Managed by user, type or select the VSAM Catalog name. The name specifies the integrated catalog facility where the data sets for this table space are catalogued. If the catalog name is greater than eight characters, then you must use an alias for this setting.
   
   
4. If you selected Managed by DB2:
   
   1. Specify a storage group nameThe 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 * 4KB.
      

   4. Optional: Select  the Erase data sets when the index is dropped radio button.
      
      
5. This is a read-only field. It shows your free space management.
   
   
6. If you selected Specify management for free space during create, the values in the Free space reserved field and the Percentage of free space in a page field are shown here.
   
   
7. From the Cache pages in a group buffer pool radio buttons, select:
   
   

   Only on Update (CHANGED)

   When more that one DB2 member has the index or partition open and at least one member has the index open for an UPDATE operations, updated pages are written to the group buffer pool.

   Always cache pages (ALL).

   Pages are cached in the group buffer when read in from DASD.

   Important: These values are ignored and no pages are cached if the group buffer pool is defined for cross-invalidation use only.
   

8. Select to compress the data.
   
9. Click OK to save your changes and close the window.