Configuring a DB2 for z/OS subsystem to tune SQL statements from IBM Data Studio

You can connect to a DB2® for z/OS® subsystem from IBM® Data Studio and configure the subsystem to tune single SQL statements by using a wizard.

Before you begin

Procedure

To configure a DB2 for z/OS subsystem to tune SQL statements from Data Studio:

  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 Analyze and Tune > Configure for Tuning > Guided Configuration. The Configure Subsystem for SQL Tuning wizard opens.
  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 advisor, and grant privileges and access to users. After you click Finish, a message lets you know whether the subsystem is successfully configured. If the subsystem is not, in the Data Source Explorer right-click the database icon for the DB2 for z/OS subsystem, and click Analyze and Tune > Configure for Tuning > Advanced Configuration and Privilege Management. In this window, you can see which parts of the configuration need to be corrected.

Results

If you successfully configured the database, you can access the features that are listed in the Data Studio column in this table: Features by product

Feedback