Implementing Siebel Business Applications on DB2 for z/OS > About Siebel Table Partitioning >

Partitioning Tables and Indexes Using the Database Storage Configurator

You can use the Database Storage Configurator file (dbconf.xls) to partition tables or customize the prepartitioned tables after you have worked out a partitioning scheme.

The following sections describe how to partition a nonpartitioned table and how to customize a partitioned table. Partitioning is carried out at the table level; however, you must also adjust the related table space and partitioning key values.

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

Partitioning a Table

The following procedure describes how to partition a nonpartitioned table in a table space.

To partition a table

1. Launch the Database Storage Configurator, and import the storage control file you want to amend.

   For information on this task, see Modifying a Storage Control File Using the Database Storage Configurator.

2. Click Structures, Table, and then select the table you want to partition.
3. Click the Partition Table button.
4. You are prompted to specify the number of partitions you want to define for the table. Enter the appropriate number and click OK.
5. Click the Structures tab, and then TBL Partition Base; enter values for the following fields:
   • SpecialCol.
   • Function
   • Column 1

     In the Column 1 field, enter the name of the column to be used to partition the table.

     Enter values for the SpecialCol and Function fields if you are partitioning the table using PARTITION_COLUMN. For information on specifying values for these fields, see Example of Partitioning the S_ADDR_ORG Table.

6. Save the values you entered by stepping off the cell but keep your cursor in the same row.
7. Click the Show Partition Parts button.
8. Enter LimitKey values for each partition you created for the table. As you step off each cell, the value is saved.
9. Select the Structures tab, and then the Tablespace tab, and locate the table space associated with the table you have partitioned.

   The table space is automatically marked as partitioned.

10. Select the table space and click the Show TSPARTS button.

    You can specify values for any of the Tsparts fields or leave them empty to accept the default values. For information on the default values, see Default Objects in Storage Control Files.

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

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.