Configuring a DB2 for Linux, UNIX, and Windows database for query tuning with InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows

You must configure your DB2® for Linux, UNIX, and Windows database before you start tuning SQL statements with InfoSphere Optim™ Query Tuner for DB2 for Linux, UNIX, and Windows.

Before you begin

Procedure

To configure a DB2 for Linux, UNIX, and Windows database for query tuning with InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows:

  1. In the Data Source Explorer, right-click the database to configure and click Analyze and Tune > Configure for Tuning > Guided Configuration.

    A message indicates whether the configuration is successful.

  2. 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.
  3. Verify that the database is configured for query tuning and that the required data objects are created, migrated, or enabled.
    1. In the Data Source Explorer, right-click the database, and then click Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management. The Advanced Configuration and Privilege Management window opens.
    2. 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 besides that object to create, migrate, or enable it.

Results

Your DB2 for Linux, UNIX, and Windows database is configured for query tuning with InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows.

During configuration, when InfoSphere Optim Query 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 Analyze and Tune > Start Tuning.
Tip: For help in the workflow assistant, click the help button Help at the top of each page and in each window that you open.

Feedback