Creating and managing tuning profiles for Db2

Edit online

A tuning profile contains information that is relevant for connecting to a subsystem, such as the subsystem name, hostname, and port. The use of tuning profiles is optional. If you choose not to use a tuning profile, you need to manually specify connection information prior to tuning a query.

Procedure

Before you create a tuning profile, make sure that the following conditions have been met:

Creating tuning profiles

Edit online

To create a tuning profile, complete the following steps:

Procedure

  1. From the navigation menu, click Db2 SQL Tuning > Profiles.
    The Profiles page opens. The Tuning profiles tab displays a list of available tuning profiles.
  2. On the Tuning profiles tab, click Create.
    The Create tuning profile page opens.
  3. Specify a name for the profile in the Profile name field and select a subsystem from the Registered subsystems drop-down list.
    Important: A subsystem is listed in the Registered subsystems drop-down list only if it has been successfully registered.
  4. Click Create.
    The tuning profile is created and listed on the Profiles page.

Viewing tuning profiles

Edit online

Before tuning an SQL query, you must select the tuning profile that is appropriate for the SQL query. You can select the appropriate tuning profile by viewing its details.

Procedure

  1. From the navigation menu, click Db2 SQL Tuning > Profiles.
    The Profiles page opens. The Tuning profiles tab displays a list of available tuning profiles.
  2. Select the tuning profile whose details you want to see, click the overflow menu, and then select View details.
    The View tuning profile page opens and displays details of the tuning profile.

Sharing tuning profiles

Edit online

By using a shared tuning profile, multiple users can tune SQL queries with the same tuning profile even though they do not own the profile. Owners of the profiles and users with administrator access to the SQL Tuning Services server can share the tuning profiles. Profiles can be shared with one or more individual users or a group of users that are included in a RACF secondary group ID.

Before you begin

Ensure that you have the permissions that are required for sharing a profile. For information about the different user roles, see the Setting up required user IDs and permissions table.

Procedure

To share a tuning profile, complete the following steps:
  1. From the navigation menu, click Db2 SQL Tuning > Profiles.
    The Profiles page opens. The Tuning profiles tab displays a list of available tuning profiles.
  2. Select the tuning profile that you want to share, and then click Share.
    The Share tuning profile page opens.
  3. Select the users or RACF secondary group ID that you want to share this profile with, and then click Share.
    The tuning profile is shared with the other users.

Deleting tuning profiles

Edit online

You can delete a tuning profile if you no longer need it. Owners of the profiles and the users with administrator access to the SQL Tuning Services server can share the tuning profiles.

Before you begin

Before you delete a tuning profile, ensure that the following conditions apply:
  • The tuning profile is not shared with other users.
  • An SQL query tuning job that is using this profile is not active.

Procedure

  1. From the navigation menu, click Db2 SQL Tuning > Profiles.
    The Profiles page opens. The Tuning profiles tab displays a list of available profiles.
  2. Select the profile that you want to delete, and then click Delete.
    The Tuning profiles tab is refreshed, and it displays the latest list of available profiles.