Preparing for recommendations for redistributing data across database partitions

Before running the Workload Design Advisor to get recommendations for redistributing data across database partitions, you must register the Database Partitioning Feature (DPF) license key.

About this task

Restriction: The Workload Design Advisor can recommend database partitioning only for DB2 Enterprise Server Edition.

Procedure

  1. Use the db2licm command to register the Database Partitioning Feature (DPF) license key. See "Registering a DB2 product or feature license key using the db2licm command".
  2. Create at least one table space in a multi-partition database partition group.
    Remember: Because the advisor can recommend data redistribution only to existing table spaces, the table spaces that you want the advisor to consider must exist in the partitioned database before the advisor is run.

What to do next

Run the Workload Design Advisor.

Feedback