Adding partition management

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

Authorities and privileges

To add partition management:

  1. In the Create Index notebook, click the Add button in the Partition Management page.

    2. The Add Partition Management window opens.
  2. In the Partition field, specify an integer that identifies the partition.
  3. Click on the Value column in the table, type a constant value and press Enter. The value is used to determine the highest value of the key in the corresponding partition of the index. For more information on the VALUE setting, see CREATE INDEX in the SQL Reference.
  4. Select Managed by user or Managed by DB2 from the Data Set Management radio buttons.
  5. 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 indexed are catalogued. If the catalog name is greater than eight characters, then you must use an alias for this setting.
  6. 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.
  7. If you want to explicitly manage free space in the index space, select the Specify management scheme for free space check box.
  8. 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.
  9. From the Cache pages in a group buffer pool radio buttons, select:
    10. 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 arecached to the group buffer pool.
  10. Click the Add push button..
  11. Specify properties for additional partitions by repeating the steps or click the Close push button.