You can connect to a DB2® for z/OS® subsystem from the IBM® Data Studio client and configure
the subsystem by using a wizard.
Procedure
To configure a DB2 for z/OS subsystem
for query tuning with the no-charge features:
- 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 |
- 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.
- 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 . The configuration wizard opens.
- Follow the instructions in the wizard.
- 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 .
You can check the status of the Query Tuner packages,
Query Tuner tables, EXPLAIN tables, and the query tuning features
in this window.