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
- 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".
- 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.