DB2 10.5 for Linux, UNIX, and Windows

Importing activity information into the Design Advisor

You can import activities collected by an activities event monitor into the Design Advisor to help you make decisions about the database objects accessed by these activities.

About this task

Activities imported into the design advisor must have been collected using the COLLECT ACTIVITY DATA WITH DETAILS or COLLECT ACTIVITY DATA WITH DETAILS AND VALUES options. The COLLECT ACTIVITY DATA WITHOUT DETAILS option is not sufficient, it will not capture the statement text which is required by the Design Advisor.

To import activity information from the activity event monitor tables into the Design Advisor, run the db2advis command with the -wlm parameter, followed by additional parameters:
  1. The activities event monitor name
  2. Optional: the workload or service class name
  3. Optional: the start time and end time
For example, to import information about all the activities collected by the DB2ACTIVITIES event monitor in the SAMPLE database, use the following command:
db2advis -d SAMPLE -wlm DB2ACTIVITIES
Note: You can only import information from activities event monitor tables through the Design Advisor command line interface.