Product components for IBM InfoSphere Optim Query Workload Tuner, Version 4.1

IBM® InfoSphere® Optim™ Query Workload Tuner, Version 4.1 consists of two components: IBM Data Studio client, Version 4.1 and a license activation kit.

For full details about installing the product and activating the full set of tuning features on DB2® databases and subsystems, see Installing IBM InfoSphere Optim Query Workload Tuner, Version 4.1.

IBM Data Studio client, Version 4.1

The product package for InfoSphere Optim Query Workload Tuner includes the IBM Data Studio client, Version 4.1 and a license activation kit. If you plan to activate the full set of product features on DB2 databases or subsystems, you must install this client on your workstation, together with the license activation kit that is in the product package.

The client provides the full set of tuning features when you connect to a DB2 database or subsystem on which a license for InfoSphere Optim Query Workload Tuner is active.

However, if you try to tune SQL statements on a DB2 database or subsystem where the full set of tuning features for InfoSphere Optim Query Workload Tuner is not activated, the IBM Data Studio client restricts the set of features that you can use. With these no-charge features, you can format SQL statements so that they are easier to read, generate visual representations of access plans, and get recommendations for collecting statistics on the objects that a statement references. You can also generate a report that summarizes information about the access plan and includes the recommendations.

For a comparison of the no-charge features and the full set of features that are in InfoSphere Optim Query Workload Tuner, see Tuning features.

License activation kit

The product package for InfoSphere Optim Query Workload Tuner, Version 4.1 contains either of these components:
  • IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows License Activation Kit, Version 4.1.0
  • IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS® License Activation Kit, Version 4.1.0

If you plan to activate the full set of tuning features on DB2 databases or subsystems, you must install on your workstation the license activation kit that is in your product package. The kit can be installed only on a workstation where the IBM Data Studio client, Version 4.1 is installed.


Feedback