Changing the database connection for Query Tuner projects

You can change the database connection of a Query Tuner project to another database connection of the same database type. This feature is useful if you need to tune SQL statements on multiple data servers within the same project.

Procedure

To change the database connection for a Query Tuner project:

  1. In the Project Explorer, expand a Query Tuner project and right-click the connection node.
  2. Select Change Connection.
  3. Select an existing connection profile from the list, or create a profile.
    Important: The new connection must be of the same type as the original connection. For example, if the original connection is a DB2® for Linux®, UNIX®, and Windows® connection, the new connection must also be a DB2 for Linux, UNIX, and Windows database connection.
  4. Click OK to change the database connection.

Results

The database connection for the project is changed. The Project Explorer is refreshed and displays the project with the changed connection.


Feedback