You can connect to a DB2® for z/OS® subsystem from the IBM® Data Studio full client and
configure the subsystem for query and query-workload tuning by using
a wizard.
About this task
If your subsystem was configured
for InfoSphere® Optim™ Query Workload Tuner, Version
3.1, then you do not need to follow the steps in this procedure.
The
procedure below explains how to use the IBM Data
Studio full client, Version 3.1.1 to create the data objects that
are required for query tuning and query-workload tuning with IBM InfoSphere Optim Query
Workload Tuner, Version 3.1.1.
For subsystems
configured for earlier versions of InfoSphere Optim Query
Tuner or InfoSphere Optim Query Workload Tuner, this
procedure also describes how you can perform either of these two actions:
- For versions 2.2.1.1 and earlier: Drop both the data objects
from those earlier versions and the data in those objects
- For version 2.2.1.1 and 2.2.1: Migrate the data objects
from those earlier versions and keep the data in those objects. For
the migration, you must have the required authorities
and privileges.
What to do next
To start tuning in the
Query Tuner Workflow Assistant,
right-click the connection in the Data Source Explorer, then click .