Using the Design Advisor
You can run the Design Advisor by invoking the db2advis command.
- Define your workload. See
Defining a workload for the Design Advisor.
- Run the db2advis command against this
workload. Note: If the statistics on your database are not current, the generated recommendations are less reliable.
- Interpret the output from db2advis and make any necessary modifications.
- Implement the Design Advisor recommendations, as appropriate.