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.
- When you connect to a subsystem in the IBM® Data Studio client, set the current SQLID
to the schema of the EXPLAIN tables.
- 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, set the current SQLID
in the global preferences.
- 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: