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: