You must configure your DB2® for Linux, UNIX, and Windows database
before you start tuning SQL statements.
The following objects are created on the database during
the configuration process:
- The license for InfoSphere® Optim™ Query Workload Tuner
- If you are using the IBM® Data
Studio client, Version 3.2, and the IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows License Activation Kit, Version 3.2.0
is installed on your workstation, you can activate the product license
on the database. You can activate the license either by running a
script or by configuring the database by using the IBM Data Studio client.
- EXPLAIN tables
- You can create a set of EXPLAIN tables manually by running a script,
or you can let the IBM Data
Studio client create a set in the SYSTOOLS schema.
- QT_WAPC* tables in the SYSTOOLS schema
- The tables are used during comparisons of access plans of SQL
statements that are in query workloads or packages.
- QT_WCC* tables in the SYSTOOLS schema
- These tables store information about query workloads.
- DB2OE.CALLDB2ADVIS stored procedure
- This stored procedure is installed only of DB2 for Linux, UNIX,
and Windows, Version 9.7.4 or earlier. It allows the Index Advisor
and the Workload Index Advisor to recommend new indexes.
- OQT.WCC_EXPLAIN_SP stored procedure
- This stored procedure gathers EXPLAIN information for the SQL
statements that are in query workloads.