The ADD clause

When you define a fragmentation strategy, you may be required to add one or more fragments. You can use the ADD clause of the ALTER FRAGMENT statement to add a new fragment to a table. Suppose that you want to add a fragment to a table that you create with the following statement:

CREATE TABLE sales (acc_num INT, ...)
   FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace2, dbspace3;

To add a new fragment dbspace4 to the table sales, execute the following statement:

ALTER FRAGMENT ON TABLE sales ADD dbspace4;