Using the IBM Data Studio full 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. If you want to drop data objects that were created for earlier versions of IBM Data Studio and you want to delete the data that is in those objects, drop the following databases.
    Important: This step is not required. Follow it only if you are sure that you want to delete the data that is in these databases.
    Option Description
    If your subsystem is configured for versions 2.2.1 or 2.2.1.1: DB2OSC
    DSNOSCDB
    AOCOEDB
    If your subsystem is configured for versions that are earlier than 2.2.1: DB2OSC
    DSNOSCDB
    DB2OE
  2. If your subsystem was configured for IBM Optimization Service Center, and before configuring for version 3.1.1 you want to drop both the data objects from those earlier versions and the data in those objects, drop databases DB2OSC and DSNOSCDB.
    Important: This step is not required. Follow it only if you are sure that you want to delete the data that is in these databases.
  3. 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.
  4. Follow the instructions in the wizard.
  5. 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