You can connect to a DB2® for z/OS® subsystem from the IBM® Data Studio full client and configure the subsystem for query and query-workload tuning by using a wizard.
If your subsystem was configured for InfoSphere® Optim™ Query Workload Tuner, Version 3.1, then you do not need to follow the steps in this procedure.
The procedure below explains how to use the IBM Data Studio full client, Version 3.1.1 to create the data objects that are required for query tuning and query-workload tuning with IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1.
To configure a DB2 for z/OS subsystem for query tuning and query-workload tuning: