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
- In the Data Source Explorer, right-click the subsystem
and select Analyze and Tune > 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.