Attaching a Table to a Fragmented Table

To attach a nonfragmented table to an already fragmented table, the nonfragmented table must have been created in a separate dbspace and must have the same table structure as the fragmented table. In the following example, a round-robin distribution scheme fragments the table cur_acct, and the table old_acct is a nonfragmented table that resides in a separate dbspace. The following example shows how to attach (as the consumed table) old_acct to cur_acct (as the surviving table):

ALTER FRAGMENT ON TABLE cur_acct ATTACH old_acct

In Dynamic Server, when you attach one or more tables to a fragmented table, a consumed_table must be nonfragmented.

In Extended Parallel Server, when you attach one or more tables to a fragmented table, a consumed_table can be nonfragmented or have hash fragmentation. If you specify a consumed_table that has hash fragmentation, the hash column specification must match that of the surviving_table and of any other consumed_table involved in the attach operation.