In IBM® Data Studio, InfoSphere™ Optim™ Query Tuner, and InfoSphere Optim Query
Workload Tuner, you can configure a DB2® for z/OS® subsystem with a wizard that
you open from the Data Source Explorer.
About this task
In Data Studio, InfoSphere Optim Query Tuner, and InfoSphere Optim Query
Workload Tuner, you can configure your subsystem
for Visual Explain in the workbench. During the configuration, follow
the wizard to bind the required packages to support Visual Explain
functions, create EXPLAIN tables to contain the performance information
about the statement, and grant privileges and access to users. If
these objects exist on the subsystem in a different format or version,
you see a message. Follow the instructions in the message to migrate
them.
Procedure
To configure a DB2 for z/OS subsystem for Visual Explain
by using the workbench in Data Studio, Optim Query
Tuner, and Optim Query Workload
Tuner:
- 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 ,
right-click the database icon for the subsystem,
and click .
- If you see a message that the format of some EXPLAIN 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 grant privileges and access to
users.
Results
After you successfully configured the subsystems, you can
use Visual Explain to view the access plan graph of your SQL statements.
What to do next
To open Visual Explain, see
Diagramming access plans with Visual Explain.