If you plan to activate licenses for IBM® InfoSphere® Optim™ Query Workload Tuner, Version
3.1.1 on DB2® databases or subsystems,
you must install both the client and the license activation kit together
on a workstation. You can install them by running a silent installation.
About this task
This task involves generating a response file on one workstations,
and then performing the installation with the response file on other
workstations.
Restrictions: - If you generate a response file on a workstation that is running
a Windows operating system,
you must perform the silent installation with that response file on
another workstation that is running a Windows operating
system.
- If you generate a response file on a workstation that is running
a Linux operating system, you
must perform the silent installation with that response file on another
workstation that is running a Linux operating
system.
Installing IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1 installs
two components on your workstation:
- IBM Data Studio full client,
Version 3.1.1
- IBM Data Studio provides
an integrated development environment for robust database application
development and database management for database servers. It includes
a limited set of features for tuning that are free of charge.
- A license activation kit for InfoSphere Optim Query Workload Tuner, Version
3.1.1
- This kit allows you to activate the full set of features for tuning
query workloads and single SQL statements. When you use the IBM Data Studio full client to start
tuning, the client will install and activate a license on the connected DB2 for Linux, UNIX,
and Windows database or DB2 for z/OS® subsystem. When you and other people subsequently
connect to that database through the IBM Data
Studio full client or administration client, you and they can use
the full set of tuning features.
- There are two different License Activation Kits:
- InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX,
and Windows License Activation
Kit
- InfoSphere Optim Query Workload Tuner for DB2 for z/OS License Activation Kit
Your product DVD or the compressed file that you downloaded from IBM Passport Advantage® of IBM Shopz contains the kit that
corresponds to the product that you purchased.
Procedure
To install both components of IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 on your workstation:
- Generate a response file:
- At a command line, change to the eclipse subdirectory
in the directory where IBM Installation
Manager is installed.
- On Windows, for example: cd
C:\Program Files\IBM\Installation Manager\eclipse
- On Linux, for example: cd
/opt/IBM/Installation Manager/eclipse
- Run one of these commands to start IBM Installation Manager.
Note: - The commands as shown will not install InfoSphere Optim Query
Workload Tuner on your workstation, and will generate a response file
only, in addition to a log file. If you want to install InfoSphere Optim Query
Workload Tuner on your workstation, remove the -skipInstall option
from the command that you run.
- Ensure the file paths you enter exist; Installation Manager will
not create directories for the response file and the log file.
If the users on the workstations where you plan to
install IBM InfoSphere Optim Query
Workload Tuner have administrative rights:
- For Windows: IBMIM.exe
–record <response file and path name> -log <log file and
path name> -skipInstall <full path name of a writable directory>
- For Linux: IBMIM
-record < full path name of the response file> -log <log
file and path name> -skipInstall < full path name of a writable
directory>
If the users on the workstations where you plan to install IBM InfoSphere Optim Query
Workload Tuner do not have administrative rights:
- For Windows: userinst.exe
–record <response file and path name> -log <log file and
path name> -skipInstall <full path name of a writable directory>
- For Linux: userinst
-record < full path name of the response file> -log <log
file and path name> -skipInstall <full path name of a writable
directory>
- In IBM Installation
Manager, select .
- On the Repositories page, add the location of the diskTag.inf files
for both IBM Data Studio full
client, Version 3.1.1 and the IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS License
Activation Kit, Version 3.1.1. Then, click OK.
The path to the
diskTag.inf file for IBM Data Studio full client:
- On Windows operating
systems: <Install media root>\disk1\diskTag.inf
- On Linux operating systems: <Install
media root>/disk1/diskTag.inf
The path to the
diskTag.inf file
for the license activation kit:
- On Windows operating
systems: <Install media root>\oqwt\diskTag.inf
- On Linux operating systems: <Install
media root>/oqwt/diskTag.inf
- In the main screen of IBM Installation
Manager, click Install.
- On the Install Packages page, follow either of these
steps. The results of these steps apply to the workstation
on which you are generating the response file, if you did not use
the -skipInstall option in step b; the results of
these steps also apply on the workstations where you perform the silent
installations.
- If you have the InfoSphere Optim Query
Tuner client, Version 3.1 or IBM Data
Studio full client, Version 3.1 installed and you want to upgrade
to IBM Data Studio full client,
Version 3.1.1, select the package group in which the product that
you want to replace appears. The Installation Manager wizard will
uninstall that product before installing IBM Data
Studio full client, Version 3.1.1.
Note: InfoSphere Optim Query Tuner client, Version 3.1 and IBM Data Studio full client, Version
3.1 could be in separate package groups or the same package group.
If they are in separate package groups, choose one of the package
groups. Installation Manager will not uninstall the client that is
in the other package group.
- If you do not have the InfoSphere Optim Query
Tuner client, Version 3.1 or IBM Data
Studio full client, Version 3.1 installed, create a new package group.
Note: If you specify a custom directory for the new
package group, ensure that the path to the directory is neither long
nor deep. The names of the directories all together should not be
long, and the path should not nest more than a few subfolders.
- Finish the remaining steps in the wizard.
- Transfer the response file to a workstation where you want
to install IBM InfoSphere Optim Query
Workload Tuner for DB2 for z/OS, Version 3.1.1. Ensure
that the version of IBM Installtion
Manager that you used to generate the response file is installed on
the workstation where you want to run the silent installation. Ensure
that the repositories that the response file specifies are accessible
by IBM Installation Manager.
For example, if the response file points to the diskTag.inf files
that are on the product DVD, place the product DVD in the DVD drive
of the workstation before starting the silent installation.
- Perform the silent installation.
- At a command line, change to the eclipse subdirectory
in the directory where IBM Installation
Manager is installed.
- On Windows, for example: cd
C:\Program Files\IBM\Installation Manager\eclipse
- On Linux, for example: cd
/opt/IBM/Installation Manager/eclipse
- Run one of these commands.
Note: The -log option
creates a new log file, so the directory that you specify must be
writable.
- For Windows: imcl.exe
-acceptLicense input <response file path and name> -log <log
file path and name>
- For Linux: ./imcl
-acceptLicense input <response file path and name> -log <log
file path and name>
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases
so that you tune SQL statements or query workloads, see Configuring DB2 for Linux, UNIX,
and Windows databases for
use with IBM InfoSphere Optim Query
Workload Tuner.
If you need to configure DB2 for z/OS subsystems
so that you can tune SQL statements or query workloads, see Configuring a DB2 for z/OS subsystem for query and query-workload
tuning with InfoSphere Optim Query Workload Tuner.
If
your subsystems or databases were already configured for tuning with IBM InfoSphere Optim Query
Workload Tuner, Version 3.1 and a license for that version is active
on the subsystem, you can start IBM Data
Studio full client and start tuning.