Setting up a basic SQL tuning environment

This article describes the minimum required steps for setting up an SQL Tuning Services environment in Db2 for z/OS Developer Extension. Additional information about optional configuration settings and features are described in Advanced options for setting up an SQL tuning environment.

Important: The SQL tuning features of Db2 Developer Extension require the Database Services Expansion Pack component of Db2 Accessories Suite 4.2. Make sure that this component is installed on your system before you start to set up your SQL tuning environment.

Adding an SQL Tuning Services server

The first step in setting up an SQL tuning environment is adding an SQL Tuning Services server.

  1. In the CONNECTIONS view, click the plus sign (+) to the right of the SQL Tuning Services servers menu item to open the Add SQL Tuning Services Server dialog.

  2. Specify the hostname or IP address and port of the system where the SQL Tuning Services server is installed and a valid user ID and password for connecting to that server.

  3. Click Finish.

    The server you just created is displayed in the SQL Tuning Services servers section of the CONNECTIONS view.

    Adding an SQL Tuning Services server

Associating a tuning connection profile with a Db2 connection

To use Db2 Developer Extension to tune your SQL, you need a tuning connection profile that’s associated with a Db2 connection.

The following steps assume that a tuning connection profile has already been created. If not, see Creating a tuning connection profile.

  1. Either create a new Db2 connection or edit an existing Db2 connection.

  2. Go to the Tuning tab and select a Tuning Services server and Tuning connection profile.

  3. Save the Db2 connection.

    Associating a tuning connection profile

Now you can start using the Visual Explain, Statistics Advisor, and Capture Query Environment tuning features of Db2 Developer Extension.