EXPLAIN tables are at an out-of-date version

Follow these steps when an error message requires you to migrate EXPLAIN tables to the latest version for your version of DB2® for z/OS®.

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

To migrate EXPLAIN tables that are in an out-of-date format by using the IBM® Data Studio client:
  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. In the EXPLAIN section, click Migrate.
To migrate EXPLAIN tables 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