Configuring DB2 for z/OS subsystems for Visual Explain by using the workbench

In IBM® Data Studio, InfoSphere™ Optim™ Query Tuner, and InfoSphere Optim Query Workload Tuner, you can configure a DB2® for z/OS® subsystem with a wizard that you open from the Data Source Explorer.

Before you begin

About this task

In Data Studio, InfoSphere Optim Query Tuner, and InfoSphere Optim Query Workload Tuner, you can configure your subsystem for Visual Explain in the workbench. During the configuration, follow the wizard to bind the required packages to support Visual Explain functions, create EXPLAIN tables to contain the performance information about the statement, and grant 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 Visual Explain by using the workbench in Data Studio, Optim Query Tuner, and Optim Query Workload Tuner:

  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 , right-click the database icon for the subsystem, and click Analyze and Tune > Configure for Tuning > Guided Configuration.
  3. If you see a message that the format of some EXPLAIN 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 grant privileges and access to users.

Results

After you successfully configured the subsystems, you can use Visual Explain to view the access plan graph of your SQL statements.

What to do next

To open Visual Explain, see Diagramming access plans with Visual Explain.

Feedback