IBM Db2 11.1 Certification Guide

Detaching a data partition

Detaching a data partition from the base table consists of two phases: the logical partitions detach, and converting the detached partition into a standalone base table through an asynchronous index clean-up process.

You can use the ALTER TABLE ... DETACH PARTITION statement to detach a data partition from the base table:

ALTER TABLE STAGING.SALES_ORDER_INCR_STG  
DETACH PARTITION PART102 INTO STAGING.SALES_ORDER_INCR_STG_102;  

You can view the asynchronous partition detach operation by executing the LIST UTILITIES command:

LIST UTILITIES SHOW DETAIL;