You must configure your DB2® for Linux, UNIX, and Windows database
for IBM® Data
Studio before
you start tuning SQL statements with it.
About this task
You can configure your database to create EXPLAIN and
ADVISE tables from Data Studio.
These tables are used for query tuning. If these tables exist in the
database in a different format or version, you see a message. Follow
the instructions in the message to migrate the tables to the current
version or format.
Procedure
To configure a DB2 for Linux, UNIX, and Windows database
to tune SQL statements:
- In the Data Source Explorer,
right-click the database that you want to configure and click .
A message indicates whether the configuration is successful.
- If you see a message that the format of some tables is
not correct during the configuration process, follow the instructions
in the message to migrate the EXPLAIN and ADVISE tables by running
the given SQL statements on the database.
- Verify that the database is configured for query tuning
and that the Index Advisor stored procedure is enabled:
- In the Data Source Explorer,
right-click the database, and then click . The Advanced Configuration and Privilege Management window
opens.
You can check the status of the EXPLAIN tables, automatic
statistics collection, and the query tuning features.
- If the EXPLAIN tables are not enabled, follow the instructions
in the message to enable the EXPLAIN tables.
- Close the Advanced Configuration and Privilege
Management window.