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.