Changing partition management

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

Authorities and privileges

To change partition management:

  1. In the 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. 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 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.

  5. If you want to explicitly manage free space in the table space, select the Specify management scheme for free space check box.

  6. If you selected Specify management for free space, specify a values in the Free space reserved field and the Percentage of free space in a page field.

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

    8. 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.
    No caching (NONE)

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

  8. Select the Compress data in the table space or partition to compress the data in the rows.

  9. Optional: Select the check box to decide whether DB2 tracks modified pages in the space map pages of the table space or partition. If you choose to let DB2 track changes, you could see some improvement in the performance of incremental image copies. If you clear the check box, DB2 uses the LRSN value in each page to determine whether a page has been changed. This should not be used for a LOB table space.

  10. Click OK.