Before you can configure a DB2® for Linux®, UNIX®, and Windows® database
for query tuning from the client and use the advanced query-tuning
features of IBM® Optim™ Query Tuner for DB2 for Linux, UNIX, and Windows,
you must activate the product license and enable the Index Advisor
stored procedure on the database.
About this task
You can run an installation program on a database to activate
the license and enable the Index Advisor stored procedure. You can
use the installation wizard or the console mode. Optionally, you can
use a response file to install silently.
If you do not activate
the license for your product, you can access only the Data Studio
IDE and Data Studio stand-alone features. For a list of features,
see Single-query tuning features by product.
Procedure
To activate the product license and enable the Index
Advisor stored procedure:
- Insert the server activation DVD for IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows Version
2.2.1 into the DVD drive of the database server.
- Run the installation program. Use one of the following
options.
Option |
Description |
Use the installation wizard |
- Open the directory with the name that indicates your platform.
- Run the following command to open the wizard:
- On Windows: install.exe
- On Linux or UNIX: ./install.bin
- Follow the instructions in the wizard to complete the steps.
- Click Done to close the wizard.
|
Use the console mode |
- In a command line, navigate to the directory with the name that
indicates your platform.
- Run the following command:
- On Windows: install.exe
-i console
- On Linux or UNIX: ./install.bin -i console
- Follow the instructions in the console to complete the process.
- Press Enter to exit the console panel.
|
Use silent installation |
- Open the directory with the name that indicates your platform.
- Copy the OQTLUWS.RSP file, which is the sample
response file, from the DVD to the database server.
- Modify the OQTLUWS.RSP file for your environment.
- In a command line, navigate to the directory that indicates your
platform, and then run the following command:
- On Windows: install.exe
-i silent -f response_file_path_and_name
- On Linux or UNIX: ./install.bin -i silent -f response_file_path_and_name
- When the installation is finished, verify that it is successful
by checking the OQTinstall_details_system_date.log or OQTinstall_summary_system_date.log file,
which is in the following default directory:
- On Windows: C:\Documents
and Settings\user_name\oqt\logs
- On Linux or UNIX: home_directory/oqt/logs
|