Eliminating unnecessary partitioning indexes

You can reclaim the space used by partitioning indexes by converting to table-controlled partitioning. A partitioning index requires as many data sets as the partitioned table space.

About this task

In table-controlled partitioning, partitioning key and limit keys are specified in the CREATE TABLESPACE statement and not the CREATE INDEX statement, which eliminates the need for any partitioning index data sets.

Procedure

To eliminate the disk space that is required for the partitioning index data sets:

  1. Drop partitioning indexes that are used solely to partition the data, and not to access it.
  2. Convert to table-controlled partitioning.