Configuring DB2 for z/OS subsystems for use with IBM InfoSphere Optim Query Workload Tuner

After you install the two components of IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS on your workstation, you can configure your DB2® for z/OS® subsystems for tuning SQL statements and workloads.

The two components are the IBM® Data Studio full client, Version 3.1.1 and the IBM InfoSphere® Optim™ Query Workload Tuner for DB2 for z/OS License Activation Kit, Version 3.1.1. Both of these components are included in the product DVD and in the package that is available on IBM Shopz.

Configuring for tuning includes creating EXPLAIN tables and other tables, table spaces, indexes, and aliases. It also includes binding required packages. You can carry out this task either by running JCL on your subsystem, or by connecting to the subsystem with the IBM Data Studio full client and using a configuration wizard.

If you configured a subsystem for tuning with InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 2.2.1, you must migrate the tables and other objects, so that you can use them with InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 3.1.1.

If you want to upgrade your DB2 for z/OS subsystem after you configure for tuning, you must run a JCL job to migrate the EXPLAIN tables and other objects that InfoSphere Optim Query Workload Tuner uses.

When you configure a subsystem for tuning, you can also do one or more optional configuration tasks, such as setting up the administrative scheduler to schedule tasks that are related to tuning query workloads.


Feedback