Verifying the configuration of a subsystem for query-workload tuning

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

Procedure

  1. Right-click the database or subsystem and select Query Tuner > Configure for Tuning > Advanced Configuration and Privilege Management.
  2. In the Query Tuner section, check that the Query Tuner packages and Query Tuner tables are enabled.
  3. In the EXPLAIN Tables section, check that the your authorization ID is has access to a set of EXPLAIN tables.
  4. 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.

Feedback