Migrating EXPLAIN tables

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