Follow these instructions to migrate from InfoSphere Optim
Query Tuner, Version 3.1 or InfoSphere Optim Query Workload Tuner,
Version 3.1 to InfoSphere Optim Query Workload Tuner for DB2 for z/OS,
Version 3.1.1.
Before you begin
- Ensure that your computer and database server meet system requirements:
- V9.1 One of the following:
- CREATEIN privilege on the schema of the UDF
- SYSADM or SYSCTRL
- V10 One of the following:
- CREATEIN privilege on the schema of the UDF
- SYSADM or SYSCTRL System DBADM
About this task
The features for query and query-workload
tuning with InfoSphere Optim Query Workload Tuner for DB2 for z/OS,
Version 3.1.1 are located in the IBM Data Studio full client and administration
client. To use the full set of features for tuning queries and query
workloads that run on a subsystem, you must activate the license for
InfoSphere Optim Query Workload Tuner for DB2 for z/OS. If you do
not activate the license, you are limited to using the no-charge tuning
features.
To activate the license, you must create
the required files on a client machine where IBM Data Studio full
client is installed. You create these files by running the License
Activation Kit. You need to run this kit on only one client machine.
Use the IBM Data Studio full client on that machine to connect to
a DB2 for LUW database for the first time. The IBM Data Studio full
client will recognize that the InfoSphere Optim Query Workload Tuner
license is not yet activated on the database, and the client will
activate the license. Subsequent users can connect to that database
through IBM Data Studio full client or IBM Data Studio administration
client and use InfoSphere Optim Query Workload Tuner, even if the
License Activation Kit was not run on their client machine.
Procedure
To migrate to InfoSphere Optim Query Workload Tuner for
DB2 for z/OS, Version 3.1.1:
Restriction: You cannot follow
these steps to migrate from releases of InfoSphere Optim Query Tuner
for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for DB2
for z/OS that are earlier than version 3.1. You must
uninstall the InfoSphere Optim Query Tuner client and
then follow the steps in
- Optional: Export your Query Tuner projects
from the InfoSphere Optim Query Tuner client.
- In the InfoSphere Optim Query Tuner client, select .
- In the Export window, expand Query
Tuner and select Projects.
- Select the projects that you want to export, select
the directory to which you want to export them, and click Finish.
- Install IBM Data Studio full client, Version 3.1.1.
On the Install Packages page of the IBM
Installation Manager wizard, select the option Use the
existing package group. Then, select the package group IBM
InfoSphere Optim.
- Start the IBM Data Studio full client. When Data Studio
asks you to select a workspace, select the workspace that you used
with the InfoSphere Optim Query Tuner client.
- If you find any problems with your Query Tuner projects,
delete the ones in error and import them from the directory that you
exported them to in step 1.
- Run the License Activation Kit. The
kit installs files that allow you to activate licenses for InfoSphere
Optim Query Workload Tuner on supported DB2 for Linux, UNIX, and Windows
databases.
Note: Only the person or persons who will activate
the license on databases are required to follow this step.
- Optional: Configure the database
by running scripts, which are located in the installation directory
for IBM Data Studio full client.
- If you installed IBM Data Studio full client on a computer
that is running a supported version of Windows: Follow the instructions
that are in the file <installation directory>\QueryTunerServerConfig\all_features\LUW\enablement_win.bat.
- If you installed IBM Data Studio full client on a computer
that is running a supported version of Linux or UNIX: Follow the
instructions that are in the file <installation directory>/QueryTunerServerConfig/all_features/LUW\enablement_LinuxUnix.sh.
- In IBM Data Studio full client, connect
to a DB2 for Linux, UNIX, and Windows database in either the Data
Source Explorer or the Administration Explorer.
- Follow the step that corresponds
to the view that you used to connect to the database.
- In the Data Source Explorer, select .
- In the Administration Explorer, select .
If you did step 7, the Query Tuner Workflow
Assistant opens to the Capture section,
from which you can locate the SQL statements that you want to tune.
If
you did not do step 7, the Query Tuner Workflow Assistant automatically
configures the database, if your user ID has the correct authorities
and privileges. As part of this configuration process, the Query
Tuner Workflow Assistant creates a set of EXPLAIN tables
in the SYSTOOLS schema.
In both cases, the
license for InfoSphere Optim Query Workload Tuner is now activated
on the DB2 for Linux, UNIX, and Windows database on which you did
steps 7 through 9. You can proceed with using the full set of features
for tuning queries and query workloads on that database. Moreover,
other users of IBM Data Studio full client and users of IBM Data Studio
administration client can also use the full set of tuning features
on that database, if they have the necessary authorizations and privileges.
- Follow steps 7 through 9 for every DB2 for Linux, UNIX,
and Windows database on which you want to activate the license for
the full set of tuning features.