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.
Procedure
To migrate EXPLAIN tables, follow one of these steps:
- Run the db2exmig tool. See
the documentation for your 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
- In the IBM Data Studio
client, right-click the database in the Data Source Explorer. Then,
select . A warning message appears to
tell you that the EXPLAIN tables need to be migrated. The message
lists a number of ALTER statements. Copy the statements and run them.