1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Changing the Number of Table Space Partitions

Changing the Number of Table Space Partitions

The following procedure describes how to increase or decrease the number of partitions for a partitioned table in a given table space.

To change the number of table space partitions

  1. Launch the Database Storage Configurator, and import the storage control file you want to amend as described in Modifying a Storage Control File Using the Database Storage Configurator.

  2. Click Structures, and then Table, and locate the name of the table space associated with the table for which you want to change the number of partitions.

  3. Click Structures, and then Tablespace, and locate the appropriate table space.

  4. Change the value in the Partitions column as appropriate. Save the new value by stepping off the cell but keep your cursor in the same row.

  5. Click Show TSPARTs.

    If you have changed the number of partitions to a lower value, a message appears indicating that there are additional table space partitions for this table. Review and delete the additional partitions.

    If you have increased the number of partitions for a table space, you receive a message indicating that the partitions have been created.

  6. Click Structures, TBL Partition Base, and locate the table you are amending.

  7. In the Partitions column, update the number of partitions to match the number of table space partitions you entered previously, then step off the cell to save the value but keep your cursor on the same row.

  8. Click Show Partition Parts.

    • If you decreased the number of partitions, review and delete the additional Partition Part definitions.

    • If you increased the number of partitions, review the values in the LimitKey column, and update them appropriately.

      Note: When using Excel, you must type the first quote as two single quotes. Excel saves it as a single quote when you step off the cell. If you only enter a single quote, Excel does not save it.

  9. Make any other edits needed to the template you are using and follow the steps under Modifying a Storage Control File Using the Database Storage Configurator to verify and save your changes.