About this task
You can configure your DB2 for Linux, UNIX, and Windows database
from the client to create EXPLAIN and ADVISE tables and enable the
Index Advisor stored procedure. If these objects exist in the database
in a different format or version, you see a message. Follow the instructions
in the message to migrate these objects to the current version.
If
you are configuring your database directly on the server without using
the client, follow the instructions in the
migrate_explaintables_db2luw.ddl file
to migrate the EXPLAIN and ADVISE tables. The SQL statements that
are used for migrating the EXPLAIN and ADVISE tables are provided
in this file. You can find this file in the following locations.
- On Windows server: \serverconfig\LUW subdirectory
of the installation directory for the server-activation program. The
default installation directory is C:\Program Files\IBM\OQTS.
- On Linux or UNIX server: /serverconfig/LUW subdirectory
of the installation directory for the server-activation program. The
default installation directory is /opt/IBM/OQTS.
- On the client system: \serverconfig\LUW\ subdirectory
of the installation directory for the client. The default installation
directory is C:\Program Files\IBM\OQT2.2.1.