After you install the IBM® Data Studio full client on your workstation, you can configure your DB2® for z/OS® subsystems for tuning SQL statements and workloads.
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.