Verifying the configuration of a subsystem

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.

Feedback