If you want multiple people to use the same set of EXPLAIN
tables when they are tuning, use one of these methods to enable sharing.
Procedure
Choose one of the these four methods to enable the sharing
of a set of EXPLAIN tables:
- Create an alias that points to a set of EXPLAIN tables,
grant privileges on the EXPLAIN tables to that alias, then have users
connect to the subsystem by using that alias as their user name. If you use this method, the alias must point to a complete set
of EXPLAIN tables. It is not possible to use an alias that is defined
on a subset of EXPLAIN tables only.
- After you connect to a subsystem in the IBM® Data Studio client, set the current SQLID
to the schema of the EXPLAIN tables. The new value for the SQLID will
remain in place until the connection to the subsystem is closed.
- In the Data Source Explorer, right-click the connection
and click Connect.
- Expand the connection, right-click the subsystem, and
select .
- Type the qualifier of the EXPLAIN tables in the Default
SQLID field in the Change Default SQLID and
Schema window, and then click OK.
- Before you connect to a subsystem in the IBM Data Studio client in order to tune SQL,
set the current SQLID in the global preferences. The new value for
the SQLID will remain be in effect for all tuning that you do within
the same Data Studio workspace, until you change the value.
- In the IBM Data
Studio client, select
- In the Preferences window, expand and select EXPLAIN Options.
- In the DB2 for z/OS section,
select the connection.
- In the CURRENT SQLID field, type
the schema of the EXPLAIN tables that you want to use.
- Click Apply, and then click OK.
- In the Invoke section of the Query
Tuner workflow assistant, set the current SQLID before selecting tuning
activities. For instructions to open the Invoke section
for an SQL statement or a query workload, see the documentation for InfoSphere® Optim™ Query Workload Tuner: