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 Linux,
UNIX, and Windows, Version 3.1.1.
Before you begin
- Ensure that your computer and database server meet system requirements:
- To activate the license, you must have the authority or privilege
to run the CREATE FUNCTION statement.
- Part of this task involves configuring a database for use with
IOQWT 3.1.1. To configure a database, you must have these authorities
and privileges:
- You must have the authority to install a JAR file with a stored
procedure on the database server. For more information, see JAR file
administration on the database server.
- You must have the authorities and privileges for running the CREATE
PROCEDURE (external) statement. For more information, see CREATE PROCEDURE
(external) statement.
- You must have the authorities and privileges to create EXPLAIN
tables on your database, if these tables are not yet created.
About this task
The features for query and query-workload
tuning with InfoSphere Optim Query Workload Tuner for DB2 for Linux,
UNIX, and Windows, 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 database, you
must activate the license for InfoSphere Optim Query Workload Tuner
for DB2 for Linux, UNIX, and Windows. 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 Linux, UNIX, and Windows, Version 3.1.1:
Restriction: You
cannot follow these steps to migrate from releases of InfoSphere Optim
Query Tuner for DB2 for Linux, UNIX, and Windows or InfoSphere Optim
Query Workload Tuner for DB2 for Linux, UNIX, and Windows that are
earlier than version 3.1.
- 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.
- If you are migrating from a release that is earlier
than version 3.1: Uninstall the InfoSphere Optim Query Tuner client.
- 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.