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:
- Call the SYSINSTALLOBJECTS stored procedure, specifying
EXPLAIN in the tool-name parameter. See the documentation for your version of DB2 for Linux, UNIX, and Windows.
- Run the db2exmig tool. See
the documentation for your version of DB2 for Linux, UNIX, and Windows.
- 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.