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:- In the Data Source Explorer, expand the connection to the subsystem.
- Right-click the subsystem and select .
- In the EXPLAIN section, click Migrate.
To migrate EXPLAIN tables that are at
an out-of-date version by running DDL manually:- In the Data Source Explorer, expand the connection to the subsystem.
- Right-click the subsystem and select .
- Click the Detailed Report button.
- 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.