You can connect to a DB2® for z/OS® subsystem
from IBM® Data
Studio and
configure the subsystem to tune single SQL statements by using a wizard.
Procedure
To configure a DB2 for z/OS subsystem
to tune SQL statements from Data Studio:
- Optional: Specify whether to preserve the contents
of and privileges for the EXPLAIN tables during the migration process. By default, the contents and privileges are preserved during
the migration process. From the main menu, click . In the Preferences window, expand
the Data Management branch, and click Query
Tuner to change these settings.
- In the Data Source Explorer,
right-click the database icon for the DB2 for z/OS subsystem,
and click . The Configure Subsystem for SQL Tuning
wizard opens.
- If you see a message that the format of some EXPLAIN tables
and Query Tuner tables is not correct, follow the instructions in
the message to migrate the tables.
- Follow the instructions in the wizard to bind the required
packages, create EXPLAIN tables and other Query Tuner tables to be
used by the tuning advisor, and grant privileges and access to users.
After you click Finish, a message lets you know whether the subsystem
is successfully configured. If the subsystem is not, in the Data Source Explorer right-click
the database icon for the DB2 for z/OS subsystem,
and click . In this window,
you can see which parts of the configuration need to be corrected.
Results
If you successfully configured the database, you can access
the features that are listed in the
Data Studio column in this
table:
Features by product