You must configure your DB2® for Linux, UNIX, and Windows database
for IBM® Data
Studio before
you start tuning SQL statements with it.
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.
Results
If you successfully configured the database, you can access
the features that are listed in the
Data Studio column in this
table:
Features by product