Configuring DB2 for z/OS subsystems for Visual Explain from the workbench

In several IBM Data Studio and Optim products, you can configure a DB2® for z/OS® subsystem with a wizard that you launch from the Data Source Explorer.

Before you begin

Procedure

To configure a DB2 for z/OS subsystem for Visual Explain from the workbench:

  1. In the Data Source Explorer, right-click the subsystem and select Query Tuner > Configure for Tuning > Advanced Configuration and Privilege Management.
  2. Click the EXPLAIN Tables tab.
  3. Click the Create EXPLAIN Tables button to create a set of EXPLAIN tables.
  4. Optional: Create aliases for the set of EXPLAIN tables by clicking Create Alias for EXPLAIN Tables.
  5. Optional: Grant privileges on the set of EXPLAIN tables by clicking Manage Privileges on EXPLAIN Tables.

Feedback