Verifying that DB2 databases or subsystems are configured for single-query tuning

Before you tune an SQL statement, ensure that the necessary tables and other objects exist on the DB2® database or subsystem that the statement runs on.

Before you begin

Procedure

To verify that a DB2 database or subsystem is configured for single-query tuning:

  1. Right-click the database or subsystem and select Query Tuner > Configure for Tuning > Advanced Configuration and Privilege Management.
  2. If you are using a DB2 for Linux, UNIX, and Windows database, follow these steps:
    • In the Query Tuner section, check that EXPLAIN tables, the stored procedure for the Index Advisor, automatic statistics collection are enabled.
    • In the Features section, check that the single-query tuning features are enabled.
  3. If you are using a DB2 for z/OS subsystem, follow these steps:
    • 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 single-query tuning features are enabled.

Feedback