Configuring a DB2 for Linux, UNIX, and Windows database for query tuning with a migration script

Use a migration script to configure your DB2® for Linux, UNIX, and Windows database for query tuning, if you do not want to follow the guided configuration process from the InfoSphere Optim™ Query Tuner client to migrate the EXPLAIN tables.

The correct version of the EXPLAIN tables must be created before you can perform query tuning on the database. To migrate the EXPLAIN tables from a previous version to the current version without using the client, follow the instructions in the migrate_explaintables_db2luw.ddl migration script.

You can find this migration script in these locations in the server-side license installation directory of the database that you want to configure for query tuning, and in the installation directory for the client.
  • On Windows: \serverconfig\LUW subdirectory
  • On Linux or UNIX: /serverconfig/LUW subdirectory
  • On the client system: \serverconfig\LUW\ subdirectory

Feedback