Use this roadmap as an overview for the tasks to install IBM® InfoSphere Optim™ Query 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
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
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 required data objects 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
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:
- On the client system, install the current version of the InfoSphere 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 that
the product license is activated.
What to do next
To start tuning SQL statements:
- 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 .