Before you tune a query workload, ensure that the necessary
tables and other objects exist on the DB2® subsystem
that the SQL statements in the workload run on.
Before you begin
- Ensure that your authorization ID has SYSADM authority.
- In the Data Source Explorer, connect to the DB2 subsystem,
if the connection is not already open.
Procedure
- Right-click the database or subsystem and select Query
Tuner > Configure for Tuning > Advanced
Configuration and Privilege Management.
- In the Query Tuner section, check
that the Query Tuner packages and Query Tuner tables are enabled.
- In the EXPLAIN Tables section, check
that the your authorization ID is has access to a set of EXPLAIN tables.
- In the Features section, check that
the workload tuning features are enabled.
What to do next
If the Workload Control Center stored procedures are not
enabled and you want to use the administrative scheduler to schedule
tasks on query workloads, see the optional step in
Configuring a DB2 for z/OS® subsystem for the client
from the server side.