Using the Design Advisor

You can run the Design Advisor by invoking the db2advis command.

Procedure

  1. Define your workload.
    See Defining a workload for the Design Advisor.
  2. Run the db2advis command against this workload.
    Note: If the statistics on your database are not current, the generated recommendations are less reliable.
  3. Interpret the output from db2advis and make any necessary modifications.
  4. Implement the Design Advisor recommendations, as appropriate.