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.