Use this roadmap as an overview for the tasks to install IBM® InfoSphere Optim™ Query Workload Tuner for
DB2 for Linux, UNIX, and Windows.
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 InfoSphere Optim Query
Workload 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=swg27022397
About this task
The installation of
InfoSphere Optim Query
Workload 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 create the data objects that are required
for query tuning.
- On the client system, you need to install the InfoSphere Optim Query Tuner client.
After the installation, configure the database to enable the
facilities and objects that are required for tuning SQL statements.
Procedure
To install InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows:
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 InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows Version 3.1 is
not activated on your database, run the
installation program for server activation.
- If the license for InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows Version 3.1 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 InfoSphere Optim Query Tuner client. The steps differ depending on whether the beta version is installed.
- After the client is installed, verify that
the product license is activated.
What to do next
To start tuning in the workflow assistant for query tuning:
- Open the InfoSphere Optim Query Tuner client.
- In the Data Source Explorer, connect to the database.
- Configure the database for query tuning.
- Right-click the connection and click .
Tip: For help in the workflow assistant, click the
help button

at the top of each page and in each window that you open.