Changing partition management

Use the Change partition management window to alter properties for managing storage at the partition level.

Authorities. Authorities and privileges

To change partition management:

  1. In the Create or Alter Table space notebook, select the partition management definition that you want to change and click the Change push button in the Partition Management page.

    2. The Change Partition Management window opens.

  2. In the Partition field, specify an integer that identifies the partition. If you are altering a table space, this field is grayed out.

  3. Select Managed by user or Managed by DB2 from the Data Set Management radio buttons.
  4. 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.
  5. If you selected Managed by DB2:
    1. Specify a storage group name

      2. 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.


      3. 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.


      4. 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.

  6. This is a read-only field. It shows your free space management.
  7. 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.

  8. From the Cache pages in a group buffer pool radio buttons, select:

    9. 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.

  9. Select to compress the data.

  10. Click OK.