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 InfoSphere Optim™ Query
Workload 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 Workload 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. Use one of the these 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 OQWTLUWS.RSP file, which is the
sample response file, from the server activation disk to the database
server.
- Modify the OQWTLUWS.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 OQWTinstall_details_system_date.log or OQWTinstall_summary_system_date.log file.
By default, the files are located in the logs subdirectory
of your installation directory.
|
Results
The IBM InfoSphere Optim Query Workload 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\OQWTS.
On Linux, the default installation directory is /opt/IBM/OQWTS.