Using the IBM Data Studio client to configure DB2 for z/OS subsystems for use with the no-charge tuning features

You can connect to a DB2® for z/OS® subsystem from the IBM® Data Studio client and configure the subsystem by using a wizard.

Before you begin

Procedure

To configure a DB2 for z/OS subsystem for query tuning with the no-charge features:

  1. In the Data Source Explorer in the IBM Data Studio client, expand the connection to the subsystem. Right-click the icon for the subsystem for the subsystem and select Analyze and Tune > Configure for Tuning > Guided Configuration. The configuration wizard opens.
  2. Follow the instructions in the wizard.
  3. Verify that the subsystem is configured for query or query-workload tuning. In the Data Source Explorer, right-click the subsystem that you configured, and then click Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management.

    You can check the status of the Query Tuner packages, Query Tuner tables, EXPLAIN tables, and the query tuning features in this window.


Feedback