Activating the product license for Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS on a subsystem

Before you can configure the subsystem from the client, monitor and tune query workloads, and use the advanced query tuning features of IBM® Optim™ Query Tuner for DB2® for z/OS® or Optim Query Workload Tuner for DB2 for z/OS, you must active the product license on a DB2 for z/OS subsystem.

Before you begin

Ensure that you performed the SMP/E tape installation to extract the license file. See Installing the license file and the configuration files for Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS on a subsystem.

About this task

You can activate your product license by running a JCL job on the subsystem.

If you do not activate the license for your product, you can access only the Data Studio IDE and Data Studio stand-alone features. For a list of features, see Single-query tuning features by product.

Procedure

  1. On the subsystem, modify one of the following JCL jobs to conform to your environment:
    Product JCL job
    Optim Query Tuner for DB2 for z/OS AOCQTAC
    Optim Query Workload Tuner for DB2 for z/OS GWTQTWA
    1. Add a valid job card.
    2. Locate and change all instances of the following items as indicated:
      • Change !DSN! to the name of the DB2 subsystem.
      • Change DSNTIA!! to the plan name for DSNTIAD utility on the DB2 subsystem.
      • Change DSN!!0 to the prefix of the target library for the DB2 subsystem.
  2. Run the JCL job. The job creates a user-defined function that activates the product on the subsystem and enables advanced features of the Optim Query Tuner client for that subsystem.

Feedback