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:
- 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.