Configuring a DB2 for Linux, UNIX, and Windows database to tune SQL statements with IBM Data Studio

You must configure your DB2® for Linux, UNIX, and Windows database for IBM® Data Studio before you start tuning SQL statements with it.

Before you begin

Procedure

To configure a DB2 for Linux, UNIX, and Windows database to tune SQL statements:

  1. In the Data Source Explorer, right-click the database that you want to configure and click Analyze and Tune > Configure for Tuning > Guided Configuration.

    A message indicates whether the configuration is successful.

  2. 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

Feedback