Query Tuner tables and views are at an out-of-date version

Follow these steps when an error message requires you to migrate Query Tuner tables and views to the latest version.

To follow these steps, you must be using InfoSphere® Optim™ Query Workload Tuner for DB2® for z/OS®, Version 4.1.0.1.

To migrate Query Tuner tables and views that are at an out-of-date version by running DDL manually:

  1. In the Data Source Explorer, expand the connection to the subsystem.
  2. Right-click the subsystem and select Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management.
  3. Click the Detailed Report button.
  4. Copy and run the DDL statements that are in the section of the report that is titled DDL for Migrating Tables that are Out-of-date.

Feedback