You must configure your DB2® for Linux, UNIX, and Windows database
before you start tuning SQL statements with InfoSphere Optim™ Query
Workload Tuner for DB2 for Linux, UNIX, and Windows.
Procedure
To configure a DB2 for Linux, UNIX, and Windows database
for query tuning with InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows:
- In the Data Source Explorer,
right-click the database to configure and click .
A message indicates whether the guided configuration
is successful or if there are configuration problems.
- If you see a message indicating that a problem was encountered
during the guided configuration process, follow the instructions in
the message to resolve the problem.
- Verify that the database is configured for query tuning
and that the required data objects are created or enabled.
- In the Data Source Explorer,
right-click the database, and then click . The Advanced Configuration
and Privilege Management window opens.
- In the Configuration Status tab,
you can check the status of the tables, stored procedures, objects,
and automatic statistics collection that are required to use the query
tuning features. If a data object is disabled, follow the instructions
in the message that is displayed beside that object to create or enable
it.
Results
Your DB2 for Linux, UNIX, and Windows database
is configured for query tuning with InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows.
During
configuration, when InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows creates
the EXPLAIN tables and the EXPLAIN_GET_MSGS user-defined function,
it grants EXECUTE privilege on the EXPLAIN_GET_MSGS user-defined function
to PUBLIC.
What to do next
To start tuning in the workflow assistant for query tuning,
right-click the connection in the Data Source Explorer, then click .
Tip: For help in the workflow assistant,
click the help button

at the top of each page and in each window that you open.