Follow this checklist when you are configuring a subsystem for the first time for use with InfoSphere® Optim™ Query Workload Tuner, Version 4.1.0.1.
| Task | Authorities or privileges required |
|---|---|
| Bind packages | One of the following authorities and privileges:
|
| Free packages | One of the following authorities and privileges:
|
| Browse subsystem parameters | Both of the following authorities and privileges:
|
| Manage users | One of the following privileges or authorities:
|
| Create EXPLAIN tables | If you want to create the EXPLAIN tables in
a new database, one or more of the following privileges or authorities
for creating the database:
|
| Create aliases for existing EXPLAIN tables | One of the following privileges or authorities:
|
).If the full set of tuning features for InfoSphere Optim Query Workload Tuner is not yet activated on the subsystem by this point, the Data Studio client activates it, if the license activation kit is installed in the directory where the Data Studio client is installed on your workstation.
The configuration wizard allows you to configure the subsystem for query tuning and query-workload tuning.
You can check the status of the Query Tuner packages, Query Tuner tables, EXPLAIN tables, and the query or query-workload tuning features in this window.