Drop or merge tablespace partitions



IBM's flagship relational database management system

Drop or merge tablespace partitions

Postby markokop » Thu Sep 11, 2008 3:44 pm

Hi all,

is it possible to drop or merge particular tablespace partitions?
I need to reduce number of partitions.
markokop
 
Posts: 1
Joined: Thu Sep 04, 2008 12:16 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Drop or merge tablespace partitions

Postby satyender » Thu Oct 16, 2008 2:28 am

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;
satyender
 
Posts: 2
Joined: Wed Jul 30, 2008 12:53 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post