Before you can use the advanced query-tuning features of IBM® InfoSphere Optim™ Query Tuner for DB2 for Linux, UNIX, and Windows,
you must activate the product license.
Before you begin
In
your DB2® for Linux, UNIX, and Windows database,
ensure that the DB2_USE_DB2JCCT2_JROUTINE environment
variable is set to YES and the KEEPFENCED configuration
parameter is set to YES. For information about the DB2_USE_DB2JCCT2_JROUTINE environment
variable, see Specification of a driver for Java routines.
For information about the KEEPFENCED configuration
parameter, see Keep fenced process configuration parameter.
About this task
If you do not activate the license for your product, you
can access only the no-charge features. For a list of features, see Features by product.
Procedure
To activate the product license:
- Load the IBM InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows V3.1.0.0 Server Configuration Kit on
the machine where the database server is running.
- Run the installation program. From the directory where
you loaded the Server Configuration Kit, 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 server activation disk 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.
By default, the files are located in the logs subdirectory
of your installation directory.
|
Results
The InfoSphere Optim Query
Tuner for DB2 for Linux, UNIX, and Windows product
license is activated.
The server-side files, including the
uninstaller, are stored in the installation directory that you specified.
On Windows, the default installation directory is C:\Program Files\IBM\OQTS.
On Linux, the default installation directory is /opt/IBM/OQTS.