Implementing Siebel Business Applications on DB2 UDB for z/OS > Installing the Siebel Schema on the DB2 Host > Preparing for a Custom Installation >

Partitioning Tables and Indexes Using the Database Storage Configurator

You can use the Database Storage Configurator to partition tables after you have worked out a partitioning scheme. For guidelines about partitioning, see Understanding Siebel Partitioning.

NOTE:  The dbconf.xls spreadsheet validation option is not a substitute for using the Database Server Configuration wizard to validate the storage control file after you amend it by partitioning tables. The Validate Storage Control File option of the Database Server Configuration utility validates the new storage control file against the physical layout of the database.

Decreasing the Number of Partitions

This topic describes how to decrease the number of partitions in a table space.

To decrease the number of partitions

1. Launch the Database Storage Configurator, and import the .ctl file you want to amend as described in Modifying Storage Control Files Using the Database Storage Configurator.
2. Click the Tablespace tab on the Database Storage Configurator.
3. Locate the appropriate Tablespace, and change the value in the Partitions column to reflect the number of partitions you want to create.
4. Save the new value by stepping off the cell.
5. Click Show TSPARTs.

   If a message box appears indicating that there are additional table space partitions for this table, and requesting that you review and delete them, do so now.

   Otherwise, you receive a message indicating that the operation was successful.

6. Click the Partitioning Index tab and locate the partitioning index associated with this table space.
7. 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.
8. Click Show Index Parts.

   If a message box appears, prompting you that there are additional partitioning indexes for this table space, and requesting that you review and delete them, do so now. Proceed to Step 9.

   Otherwise, you receive a message indicating that the operation was successful.

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

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

Increasing the Number of Partitions

Usually, partitioning is carried out at the table level. However, you must also adjust the related table space and partitioning index. The following procedure describes how to increase the number of partitions for a table and an index in a given table space.

To increase the number of partitions

1. Launch the Database Storage Configurator as described in Modifying Storage Control Files Using the Database Storage Configurator, and select the Table tab.
2. Locate the name of the partitioned table space for which you want to increase the number of partitions.
3. Click the Tablespace tab, and locate the corresponding table space.
4. Increase the value in the Partitions column for that table space as appropriate and step off the cell to save the new value, but keep your cursor in the same row. (If you do not keep your cursor in the same row, you cannot get to the table space partitions by clicking the Show TSPARTs button.)
5. Click Show TSPARTs.

   When you increase the value in the Partitions column, you receive a message indicating that the partitions were added successfully.

6. Click the Partitioning Index tab, and locate the partitioning index associated with the table you are amending.
7. Increase the number of partitions to match the value you previously entered for the associated table space, and step off the cell to save the value, but keep your cursor on the same row.
8. Click Show Index Parts.

   A text box appears prompting you that the extra partitions were created successfully.

9. Review the LimitKey values and update them as appropriate.

   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 do not enter two single quotes, Excel deletes it entirely when you step off the cell.

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