Verifying the configuration of a subsystem for tuning query workloads that run on DB2 for z/OS

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