Configuring DB2 for Linux, UNIX, and Windows databases for use with IBM InfoSphere Optim Query Workload Tuner

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 user-defined function that enables the full set of tuning features for InfoSphere® Optim™ Query Workload Tuner
If you are using the IBM® Data Studio client, Version 4.1, and the IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows License Activation Kit, Version 4.1.0 is installed on your workstation, you can activate the full set of tuning on the database. You can activate these features 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.
SYSTOOLS.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.
SYSTOOLS.WCC_EXPLAIN_SP stored procedure
This stored procedure gathers EXPLAIN information for the SQL statements that are in query workloads.

Feedback