IBM Mainframe Forum

Hi all,

is it possible to drop or merge particular tablespace partitions?
I need to reduce number of partitions.

Hi,
Try the option "DETACH PARTITION".

In this example, the dec01 data partition is detached from table stock and placed in table junk. You can then drop table junk, effectively dropping the associated data partition.


ALTER TABLE stock DETACH PART dec01 INTO junk;
DROP TABLE junk;