Use this roadmap as an overview for the tasks to install IBM® Optim™ Query Tuner for DB2® for Linux, UNIX, and Windows and
to configure a DB2 for Linux, UNIX, and Windows database
for the Optim Query
Tuner client.
Before you begin
- If you want to migrate your database to another version, migrate
the database before you perform the server-side installation tasks
for Optim Query
Tuner for DB2 for Linux, UNIX,
and Windows on
the new database server.
- Ensure that your computer and database server meet system requirements: http://www.ibm.com/support/docview.wss?uid=swg27018335
About this task
The installation of
Optim Query
Tuner for DB2 for Linux, UNIX,
and Windows affects
two locations, a
DB2 database
server and a client system. On the database, you need to run an installation
program to activate the product license and enable the Index Advisor
stored procedure. On the client system, you need to install the
Optim Query
Tuner client.
After the installation, configure the database to enable the facilities
and objects for the client.
Procedure
To install Optim Query
Tuner for DB2 for Linux, UNIX,
and Windows and
configure databases for query tuning:
Note: Steps 1 and 2 can be done
in any order or concurrently.
- On each database server, activate the product license:
- If the license for Optim Query
Tuner for DB2 for Linux, UNIX,
and Windows Version
2.2 is not activated on your database, run the installation program
for server activation. See Activating
the product license and enabling the Index Advisor stored procedure.
- If the license for Optim Query
Tuner for DB2 for Linux, UNIX,
and Windows Version
2.2 is activated on your database, you do not need to activate the
current license again.
- On the client system, install the current version of the Optim Query
Tuner client. The steps differ depending on whether a previous version or
a beta version is installed.
- After the client is installed, verify the
product license.
- Configure each DB2 for Linux, UNIX, and Windows database
for query tuning.
- If you have data from a previous version or a beta version,
import the data. See Importing
projects, SQL categories, filters, and database connection profiles.
What to do next
To start tuning in the workflow assistant for query tuning:
- Open the Optim Query
Tuner client.
- In the Data Source Explorer, connect to the database.
- Right-click the connection and click .
For help in the workflow assistant, click the help button
at the top
of each page and in each window that you open.
For an introduction
to the workflow assistant for query tuning, see Workflow assistant for query tuning.