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