If you upgraded the version of DB2® for Linux, UNIX, and Windows that is managing a database, and
that database contains a set of EXPLAIN tables that you are using
with IBM® InfoSphere® Optim™ Query
Workload Tuner, you can run a script to migrate those tables so that
they are compatible with the new version of DB2 for Linux, UNIX, and Windows.
To migrate the EXPLAIN tables, follow the instructions
in the migrate_explaintables_db2luw.ddl migration
script.
You can find this migration script in these locations
in the installation directory for the IBM Data
Studio client.
- On Windows: \QueryTunerServerConfig\all_features\LUW
- On Linux or UNIX: /QueryTunerServerConfig/all_features/LUW