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 means to create EXPLAIN tables and other tables, table spaces, indexes, and aliases. It also means 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 or administration 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 carry out the task of configuring for tuning, you can also carry out one or more optional configuration tasks, such as setting up the administrative scheduler to schedule tasks related to tuning query workloads.