Chapter 3. Administration and management 87
The Design Advisor analyzes the characteristics (database and hardware
resource) of your workload to consider the costs and advantages of each feature
when formulating design recommendations. Then it weighs the performance
improvements against the costs associated with implementing the
Because the Design Advisor performs the cost-benefit analysis for you, all
features are selected by default for consideration. It is recommended that you
leave this default setting and allow the Design Advisor to determine which
features provide the greatest overall performance advantages for the workload
that you specify. If you do not want to implement specific performance
enhancement features, you can choose not to select those features for
evaluation. Eliminating those features will reduce the amount of time that the
Design Advisor spends evaluating different performance enhancement
possibilities for your database.
Using either the Design Advisor GUI or the db2advis command-line tool, the
Design Advisor can help simplify the following tasks:
Planning for or setting up a new database or partitioning structure
While designing your database or database partitions, use the Design Advisor
– Generate design alternatives in a test environment for partitioning,
indexes, MQTs, and MDC tables.
– Determine initial database partitioning before loading data into a
– Assist in migrating from a non-partitioned DB2 database to a partitioned
– Assist in migrating to DB2 in a partitioned environment from another
– Evaluate indexes, MQTs, or partitions that have been generated manually.
Note: It is very important for the Design Advisor that you provide a
representative query workload. If the workload that you submit is not
representative of the overall database activity, the recommendations might not
provide performance enhancements for queries not included in the workload.
Also, it is critical that the statistics on any object that is involved in the
workload are up-to-date. Inaccurate statistics might negatively affect the
quality of the Design Advisor recommendations.