Hello,

I have a fairly bulky table with a DPF key X that I believe is not an optimal choice. The table is defined on a multi-partition database group. Can I change the DPF key to column Y? If yes, what does it entail - dropping and recreating the table????

As always, thanks for the guidance!

G

Yes, you will have to re-create the table with the new partitioning key.

Thanks n_i! although, I want to make sure I detailed my request correctly - I am looking for the procedure to alter the DPF key and not the partitioning key (starting 9.x, I understand these two are different entities).

G

To be precise, it should be called "distribution key". You are correct that "partitioning key" applies to partitioned tables, but I meant to say "distribution key".

I would do a db2look on the table (or whole database) to see the existing table DDL. You want to change the "DISTRIBUTE BY HASH" column.

Export the existing data in del format (not IXF) before you drop the table and then load it back after you recreate the table with new DISTRIBUTE BY HASH column.

Thanks much! You guys are the best!

G