Running JCL to activate the license for InfoSphere Optim Query Workload Tuner, Version 3.1.1

You can activate the license for InfoSphere® Optim™ Query Workload Tuner by running a JCL job, if you do not want the license to be activated automatically by the IBM® Data Studio full client.

About this task

A product license must be active on each DB2® for z/OS® subsystem that you connect to through the client when you are tuning queries and query workloads.

When you connect to a DB2 for z/OS subsystem from the IBM Data Studio full client and the license activation kit is installed with the client, the client detects whether a license is not yet present on the subsystem. If a license is not present, the client installs and activates the license.

If you would rather activate the license manually on a subsystem, you can run a JCL job that is included in the installation directory for the client after you install the license activation kit.

Important: If a license for version 3.1 of IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS is already active on a subsystem that you want to use for tuning, you do not need to follow these steps. The license for version 3.1 gives you access to the new features and improvements in version 3.1.1.

Procedure

  1. Upload the following file to the subsystem where you want to activate the license: qwt_license.jcl This file is in the QueryTunerServerConfig\all_features\ZOS\License\ folder in the installation directory for the IBM Data Studio full client.
  2. Replace the variables $$DSN and $$USER with values for your system environment and submit the job.

What to do next

In the Data Source Explorer view in the IBM Data Studio full client, Version 3.1.1 or in the IBM Data Studio administration client, Version 3.1.1, you can connect to the subsystem and begin tuning queries and query workloads.

Feedback