Configuring a DB2 for z/OS subsystem from the Optim Query Tuner client

You can connect to a DB2® for z/OS® subsystem from the Optim™ Query Tuner client and configure the subsystem for query tuning with a wizard in the client.

Before you begin

About this task

You can configure your DB2 for z/OS subsystem from the client by binding the required packages, creating EXPLAIN and Query Tuner tables, enabling the stored procedures, and granting privileges and access to users. If these objects exist on the subsystem in a different format or version, you see a message. Follow the instructions in the message to migrate them.

Procedure

To configure a DB2 for z/OS subsystem for query tuning from the Optim Query Tuner client:

  1. Optional: Specify whether to preserve the contents of and privileges for the EXPLAIN tables during the migration process. By default, the contents and privileges are preserved during the migration process. From the main menu, click Window > Preferences. In the Preferences window, expand the Data Management branch, and click Query Tuner to change these settings.
  2. In the Data Source Explorer, right-click the database icon for the DB2 for z/OS subsystem, and click Query Tuner > Configure for Tuning > Guided Configuration.
  3. If you see a message that the format of some EXPLAIN tables and Query Tuner tables is not correct, follow the instructions in the message to migrate the tables.
  4. Follow the instructions in the wizard to bind the required packages, create EXPLAIN tables and other Query Tuner tables to be used by the tuning advisors, and grant privileges and access to users.
  5. If you see a message that the stored procedures are not enabled, follow the instructions in the message to enable the stored procedures from the server.

    For detailed instructions, refer to step 3 in this documentation: Configuring a DB2 for z/OS subsystem for the Optim Query Tuner client from the server

  6. Verify that the subsystem is configured for query or query-workload tuning:
    1. In the Data Source Explorer, right-click the database that you configured, and then click Query Tuner > Configure for Tuning > Advanced Configuration and Privilege Management. The Advanced Configuration and Privilege Management window opens.

      You can check the status of the Query Tuner packages, Query Tuner tables, EXPLAIN tables, and the query or workload tuning features in this window.

    2. In the Query Tuner section, if the Query Tuner packages are not enabled, follow the instructions in the message to bind the packages.
    3. In the Query Tuner section, if the Query Tuner tables are not enabled, follow the instructions in the message to migrate or create the tables.
    4. In the EXPLAIN tables section, if the EXPLAIN tables are not enabled, follow the instructions in the message to migrate or create the EXPLAIN tables.
  7. Close the Advanced Configuration and Privilege Management window.

Feedback