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 license for InfoSphere® Optim™ Query Workload Tuner
If you are using the IBM® Data Studio full client, Version 3.1.1, and the IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows License Activation Kit, Version 3.1.1 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 full 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_WCC* tables in the SYSTOOLS schema
These tables store information about query workloads.
The DB2OE.CALLDB2ADVIS stored procedure
This stored procedure allows the Index Advisor and the Workload Index Advisor to recommend new indexes.
The OQT.WCC_EXPLAIN_SP stored procedure
This stored procedure gathers EXPLAIN information for the SQL statements that are in query workloads.