IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1
Installation Guide
Note
Before using this information and the product it supports, read
the information in Notices.
This edition applies to version 3.1.1 of IBM InfoSphere Optim Query
Workload Tuner and to all subsequent releases and modifications until
otherwise indicated in new editions.
Copyright International Business Machines Corporation 2012.
US Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Installing IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1
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 and a license activation kit for InfoSphere Optim Query Workload Tuner, Version 3.1.1
- 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. You use
this client for your tuning tasks. You can do a limited set of no-charge
tuning tasks, or you can access the full set of tuning tasks for any
databases that have on which a license for IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 is active.
- 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. After the licence is activated
on that database or subsystem, the full set of tuning features is
available to anyone else who connects to that database or subsystem
through the Data Studio full client or administration client, Version
3.1.1.
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:
- 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
You can install both components or only
one of them, depending on your requirements.
- You can install both if neither of them are yet installed on your
workstation and you plan to use the license activation kit to activate
licenses on DB2 databases or
subsystems.
- You can install the Data Studio full client alone, if you have
no need to install the license activation kit.
- You can install the license activation kit alone if the Data Studio
full client 3.1.1 is already installed on your workstation.
You can also choose whether to install these components
through a wizard or silently with a response file.
Installing Data Studio and the license activation kit for IBM InfoSphere Optim Query
Workload Tuner through a wizard
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 using the IBM Installation Manager wizard, which you open
from the product launchpad.
Before you begin
Ensure that your workstation meets the system requirements.
About this task
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. You use
this client for your tuning tasks. You can do a limited set of no-charge
tuning tasks, or you can access the full set of tuning tasks for any
databases that have on which a license for IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 is active.
- 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. After the licence is activated
on that database or subsystem, the full set of tuning features is
available to anyone else who connects to that database or subsystem
through the Data Studio full client or administration client, Version
3.1.1.
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:
- 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
Procedure
To install both components of IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 on your workstation:
- If IBM
Installation Manager is already installed on the workstation, ensure
that it checks automatically for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
If IBM Installation Manager is not already installed on the
workstation, it is installed automatically in the next step.
- On the product DVD or in the extracted content of the compressed
file that you downloaded from IBM Passport Advantage,
double-click the appropriate file for your operating system:
- On Windows operating
systems: setup.exe
- On Linux operating systems: setup
If Installation Manager 1.5.1 is not already installed on the
workstation, it is automatically installed at this point.
- In the launchpad, select Install Product and select the
type of installation to perform.
- On the Select Packages page of the wizard, select both
packages.
- On the Install Packages page, specify an existing package
group or a new package group depending on whether you are upgrading
an existing product:
- Upgrading an existing client
- 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.
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.
- Installing a new client
- 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.
- Finish the remaining steps in the wizard.
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases so that you can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Installing Data Studio and the License Activation Kit for IBM InfoSphere Optim Query
Workload Tuner silently
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.
Before you begin
Ensure that your workstation and the workstations
where you plan to run the silent installation meet the system requirements.
About this task
This task involves generating a response file on one workstation,
and then performing the installation with the response file on other
workstations. The workstation where you generate the response file
must already have IBM Installation
Manager installed.
Installing IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1 installs
two components on a 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. You use
this client for your tuning tasks. You can do a limited set of no-charge
tuning tasks, or you can access the full set of tuning tasks for any
databases that have on which a license for IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 is active.
- 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. After the licence is activated
on that database or subsystem, the full set of tuning features is
available to anyone else who connects to that database or subsystem
through the Data Studio full client or administration client, Version
3.1.1.
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:
- 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
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.
Procedure
To install both components of IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 on your workstation:
- Ensure that IBM Installation
Manager checks automatically for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- Generate a response file:
- At a command line, change to the eclipse subdirectory
in the directory where IBM Installation
Manager is installed. The default path to the subdirectory
depends on your operating system and whether you have administrative
rights on the workstation.
- If you have administrative rights on the workstation:
-
- On Windows: C:\Program
Files\IBM\Installation Manager\eclipse
- On Linux: /opt/IBM/Installation
Manager/eclipse
- If you do not have administrative rights on the workstation:
-
- On Windows 2000 and Windows XP Professional: C:\Documents
and Settings\user\IBM\Installation Manager
- On Windows Vista, Windows 2008, and Windows 7: C:\Users\users\IBM\Installation
Manager
- On Linux: /user_home_directory/IBM/InstallationManager
- Run one of these commands to start IBM Installation Manager, to generate a response
file, and to generate a log file. When you specify the command, ensure
that the file paths you enter exist; Installation Manager will not
create directories for the response file and the log file. If
you want to install InfoSphere Optim Query Workload Tuner on your
workstation, in addition to generating the response file, remove the
-skipInstall option from the command that you run.
- Command to run 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_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
IBMIM
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- Commands to run 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_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
userinst
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- In IBM Installation
Manager, select File > Preferences.
- 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: Root_path_of_installation_media\disk1\diskTag.inf
- On Linux operating systems: Root_path_of_installation_media/disk1/diskTag.inf
The path to the diskTag.inf file
for the license activation kit:
- On Windows operating
systems: Root_path_of_installation_media\oqwt\diskTag.inf
- On Linux operating systems: Root_path_of_installation_media/oqwt/diskTag.inf
- In the main screen of IBM Installation
Manager, click Install.
- On the Install Packages page, specify an existing package
group or a new package group depending on whether you are upgrading
an existing product. 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.
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.
- Finish the remaining steps in the wizard.
The response file is generated at the location that you
specified when you ran the command.
- Transfer the response file to a workstation where you want
to install IBM InfoSphere Optim Query
Workload Tuner, Version 3.1.1. Ensure that IBM Installation Manager 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.
- Ensure that IBM Installation
Manager checks automatically for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- 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 the command to start the silent installation. 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_name_and_path -log log_file_name_and_path
- For Linux: ./imcl
-acceptLicense input response_file_name_and_path -log log_file_name_and_path
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases so that you can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Installing only the IBM Data
Studio full client, Version 3.1.1 for IBM InfoSphere Optim Query Workload Tuner through a wizard
You can choose to install only the IBM Data Studio full
client through IBM Installation Manager.
Before you begin
Ensure that your workstation meets the system requirements.
About this task
You might want to install only the IBM Data Studio full client, Version 3.1.1 in
either of these situations:
- The IBM InfoSphere Optim Query
Tuner client, Version 3.1.1 is installed on your workstation and you
want to upgrade to IBM Data
Studio full client, Version 3.1.1. You can connect to databases and
subsystems on which the license for IBM InfoSphere Optim Query Workload Tuner, Version 3.1 is
active and use the full set of features in Version 3.1.1.
- You do not need to install the license activation kit because
you will not be activating product licenses on DB2 databases or subsystems.
Procedure
To install only the IBM Data Studio full client through
IBM Installation Manager:
- If IBM
Installation Manager is already installed on the workstation, ensure
that it checks automatically for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- On the product DVD or in the extracted content of the compressed
file downloaded from IBM Passport Advantage,
double-click either of these files, depending on your operating system:
- On Windows operating
systems: setup.exe
- On Linux operating systems: setup
- In the launchpad, select Install Product and select the
type of installation that you want to perform.
- On the Select Packages page of the wizard, select the package
for the IBM Data Studio full
client, Version 3.1.1.
- On the Install Packages page, follow either of these steps:
- 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.
- Finish the remaining steps in the wizard.
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases so that you can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Installing only the IBM Data
Studio full client, Version 3.1.1 for IBM InfoSphere Optim Query Workload Tuner silently
You can choose to install only the IBM Data Studio full
client silently.
Before you begin
Ensure that any version of IBM Installation
Manager from 1.3.3 through 1.5 is installed on your workstation.
About this task
You might want to install only the IBM Data Studio full client, Version 3.1.1 in
either of these situations:
- The IBM InfoSphere Optim Query
Tuner client, Version 3.1.1 is installed on your workstation and you
want to upgrade to IBM Data
Studio full client, Version 3.1.1. You can connect to databases and
subsystems on which the license for IBM InfoSphere Optim Query Workload Tuner, Version 3.1 is
active and use the full set of features in Version 3.1.1.
- You do not need to install the license activation kit because
you will not be activating product licenses on DB2 databases or subsystems.
This task involves generating a response file on one workstations,
and then performing the installation with the response file on other
workstations. The workstation where you generate the response file
must already have IBM Installation
Manager installed.
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.
Procedure
To install only the IBM Data Studio full client silently:
- Ensure that IBM Installation Manager checks automatically
for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- Generate a response file:
- At a command line, change to the eclipse subdirectory
in the directory where IBM Installation
Manager is installed. The default path to the subdirectory
depends on your operating system and whether you have administrative
rights on the workstation.
- If you have administrative rights on the workstation:
-
- On Windows: C:\Program
Files\IBM\Installation Manager\eclipse
- On Linux: /opt/IBM/Installation
Manager/eclipse
- If you do not have administrative rights on the workstation:
-
- On Windows 2000 and Windows XP Professional: C:\Documents
and Settings\user\IBM\Installation Manager
- On Windows Vista, Windows 2008, and Windows 7: C:\Users\users\IBM\Installation
Manager
- On Linux: /user_home_directory/IBM/InstallationManager
- Run one of these commands to start IBM Installation Manager, to generate a response
file, and to generate a log file. When you specify the command, ensure
that the file paths you enter exist; Installation Manager will not
create directories for the response file and the log file. If
you want to install the IBM Data
Studio full client, Version 3.1.1 on your workstation, in addition
to generating the response file, remove the -skipInstall option from
the command that you run.
- Command to run if the users on the workstations where you plan
to install the IBM Data Studio
full client have administrative rights
-
- For Windows:
IBMIM.exe
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
IBMIM
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- Commands to run if the users on the workstations where you plan
to install the IBM Data Studio
full client do not have administrative rights
-
- For Windows:
userinst.exe
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
userinst
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- In IBM Installation
Manager, select File > Preferences.
- On the Repositories page, add the location of the diskTag.inf file
for the IBM Data Studio full
client, Version 3.1.1. Then, click OK.
The path to the diskTag.inf file for IBM Data Studio full client:
- On Windows operating
systems: Root_path_of_installation_media\disk1\diskTag.inf
- On Linux operating systems: Root_path_of_installation_media/disk1/diskTag.inf
- In the main screen of IBM Installation
Manager, click Install.
- On the Select Packages page of the wizard, select the
package for the IBM Data Studio
full client.
- On the Install Packages page, specify an existing package
group or a new package group depending on whether you are upgrading
an existing product. 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.
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.
- Finish the remaining steps in the wizard.
The response file is generated at the location that you
specified when you ran the command.
- Transfer the response file to a workstation where you want
to install the IBM Data Studio
full client, Version 3.1.1. Ensure that IBM Installation Manager 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 file that
is on the product DVD, place the product DVD in the DVD drive of the
workstation before starting the silent installation.
- Ensure that IBM Installation Manager checks automatically
for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- 3. 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 the command to start the silent installation. 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_name_and_path -log log_file_name_and_path
- For Linux: ./imcl
-acceptLicense input response_file_name_and_path -log log_file_name_and_path
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases so that you can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Installing only the license activation kit for IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 through a wizard
You can choose to install the license activation kit only
and use a wizard to install it.
Before you begin
Ensure that the IBM Data Studio full client, Version 3.1.1
is already installed on the workstation where you plan to install
the license activation kit.
About this task
You might want to install only the license activation kit
if the IBM Data Studio full
client, Version 3.1.1 is installed on your workstation and you plan
to activate licenses for IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1,
so that everyone who connects to your databases and subsystems through
an IBM Data Studio client can
access the full set of tuning features.
Procedure
To install only the license activation kit for IBM InfoSphere Optim Query
Workload Tuner, Version 3.1.1 through a wizard:
- If IBM
Installation Manager is already installed on the workstation, ensure
that it checks automatically for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- On the product DVD or in the extracted content of the compressed
file downloaded from IBM Passport Advantage,
double-click the appropriate file for your operating system:
- On Windows operating
systems: setup.exe
- On Linux operating systems: setup
- In the launchpad, select Install Product and select the
type of installation that you want to perform.
- On the Select Packages page of the wizard, select the package
for the license activation kit.
- 4. On the Install Packages page, select the package group
in which IBM Data Studio full
client, Version 3.1.1 is installed.
- Finish the remaining steps in the wizard.
What to do next
If you need to configure DB2 for Linux, UNIX, and Windows databases so that you can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Installing only the license activation kit for IBM InfoSphere Optim Query Workload Tuner, Version
3.1.1 silently
You can choose to install the license activation kit only
and install it through a silent installation.
Before you begin
- Ensure that any version of IBM Installation
Manager from 1.3.3 through 1.5 is installed on your workstation.
- Ensure that the IBM Data Studio full client, Version 3.1.1 is
already installed on the workstations where you plan to install silently
the license activation kit.
About this task
You might want to install only the license activation kit
if the IBM Data Studio full
client, Version 3.1.1 is installed on your workstation and you plan
to activate licenses for IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1,
so that everyone who connects to your databases or subsystems through
an IBM Data Studio client can
access the full set of tuning features.
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.
Procedure
To install only the license activation kit silently:
- Ensure that IBM Installation Manager checks automatically
for updates to itself.
- Launch IBM Installation Manager.
- Select File > Preferences.
- In the Preferences window, select Updates.
- On the Updates page, select the option Search
for Installation Manager updates. Then, click OK.
- Close IBM Installation Manager.
- Generate a response file:
- At a command line, change to the eclipse subdirectory
in the directory where IBM Installation
Manager is installed. The default path to the subdirectory
depends on your operating system and whether you have administrative
rights on the workstation.
- If you have administrative rights on the workstation:
-
- On Windows: C:\Program
Files\IBM\Installation Manager\eclipse
- On Linux: /opt/IBM/Installation
Manager/eclipse
- If you do not have administrative rights on the workstation:
-
- On Windows 2000 and Windows XP Professional: C:\Documents
and Settings\user\IBM\Installation Manager
- On Windows Vista, Windows 2008, and Windows 7: C:\Users\users\IBM\Installation
Manager
- On Linux: /user_home_directory/IBM/InstallationManager
- Run one of these commands to start IBM Installation Manager, to generate a response
file, and to generate a log file. When you specify the command, ensure
that the file paths you enter exist; Installation Manager will not
create directories for the response file and the log file. If
you want to install the license activation kit on your workstation,
remove the -skipInstall option from the command that you run.
- Command to run if the users on the workstations where you plan
to install the IBM Data Studio
full client have administrative rights
-
- For Windows:
IBMIM.exe
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
IBMIM
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- Commands to run if the users on the workstations where you plan
to install the IBM Data Studio
full client do not have administrative rights
-
- For Windows:
userinst.exe
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- For Linux:
userinst
-record response_file_name_and_path
-log log_file_name_and_path
-skipInstall full_path_name_of_a_writable_directory
- In IBM Installation
Manager, select File > Preferences.
- On the Repositories page, add the location of the diskTag.inf file
for the license activation kit. Then, click OK.
The path to the diskTag.inf file for
the license activation kit:
- On Windows operating
systems: Root_path_of_installation_media\oqwt\diskTag.inf
- On Linux operating systems: Root_path_of_installation_media/oqwt/diskTag.inf
- In the main screen of IBM Installation
Manager, click Install.
- On the Select Packages page of the wizard, select the
package for the license activation kit.
- On the Install Packages page, select the package group
in which IBM Data Studio full
client, Version 3.1.1 is installed.
- Finish the remaining steps in the wizard.
- Transfer the response file to a workstation where you want
to install the license activation kit. Ensure that the
version of IBM Installation
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 file that
is on the product DVD, place the product DVD in the DVD drive of the
workstation before starting the silent installation.
- 3. 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 the command to start the silent installation.
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_name_and_path -log <log
file path and name>
- For Linux: ./imcl
-acceptLicense input response_file_name_and_path -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 can 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 databases or subsystems 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 databases or subsystems,
you can start IBM Data Studio
full client and start tuning.
Uninstalling IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1
You can use the Uninstall option in IBM Installation Manager to uninstall the product
packages for InfoSphere Optim Query Workload Tuner, Version
3.1.1.
Before you begin
- Log in to the workstation by using the same user account that
you used to install the product packages.
- Ensure that the IBM Data
Studio full client is not running.
About this task
An installation of InfoSphere Optim Query Workload Tuner consists
of the IBM Data Studio full
client, Version 3.1.1, together with either or both of the following
packages:
- IBM InfoSphere Optim Query
Workload Tuner for DB2 for Linux, UNIX, and Windows Licence
Activation Kit, Version 3.1.1.0
- IBM InfoSphere Optim Query
Workload Tuner for DB2 for z/OS Activation Kit, Version 3.1.1.0
If you uninstall IBM Data
Studio full client, Version 3.1.1, the license activation kit or kits
are uninstalled, too. However, you can uninstall the license activation
kit or kits without uninstalling IBM Data
Studio full client, Version 3.1.1.
Procedure
To uninstall the product packages for InfoSphere Optim Query
Workload Tuner, Version 3.1.1, complete the following steps:
- Start IBM Installation
Manager.
- On the Start page, click Uninstall.
- On the Uninstall Packages page, from the Installation Packages
list select the product packages that you want to uninstall and click Next.
- On the Summary page, review the list of packages that will
be uninstalled and click Uninstall. The Complete page is displayed
after the packages are removed.
- Click Finish.
Notices
Note to U.S. Government Users Restricted Rights - Use, duplication
or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
This information was developed for products and services offered
in the U.S.A. IBM may not offer
the products, services, or features discussed in this document in
other countries. Consult your local IBM representative
for information on the products and services currently available in
your area. Any reference to an IBM product,
program, or service is not intended to state or imply that only that IBM product, program, or service
may be used. Any functionally equivalent product, program, or service
that does not infringe any IBM intellectual
property right may be used instead. However, it is the user's responsibility
to evaluate and verify the operation of any non-IBM product, program,
or service.
IBM may have patents or
pending patent applications covering subject matter described in this
document. The furnishing of this document does not grant you any license
to these patents. You can send license inquiries, in writing, to:
IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.
For license inquiries regarding double-byte (DBCS) information,
contact the IBM Intellectual
Property Department in your country or send inquiries, in writing,
to:
IBM World Trade Asia Corporation
Licensing
2-31 Roppongi 3-chome, Minato-ku
Tokyo 106, Japan
The following paragraph does not apply to the
United Kingdom or any other country where such provisions are inconsistent
with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES
THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS
OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
Some states do not allow disclaimer of express or implied warranties
in certain transactions, therefore, this statement may not apply to
you.
This information could include technical inaccuracies or typographical
errors. Changes are periodically made to the information herein; these
changes will be incorporated in new editions of the publication. IBM may make improvements and/or
changes in the product(s) and/or the program(s) described in this
publication at any time without notice.
Any references in this information to non-IBM Web sites are provided
for convenience only and do not in any manner serve as an endorsement
of those Web sites. The materials at those Web sites are not part
of the materials for this IBM product
and use of those Web sites is at your own risk.
IBM may use or distribute
any of the information you supply in any way it believes appropriate
without incurring any obligation to you.
Licensees of this program who wish to have information about it
for the purpose of enabling: (i) the exchange of information between
independently created programs and other programs (including this
one) and (ii) the mutual use of the information which has been exchanged,
should contact:
Intellectual Property Department
IBM Corporation
Silicon Valley Lab
555 Bailey Avenue
San Jose, CA 95141-1003
U.S.A.
Such information may be available, subject to appropriate terms
and conditions, including in some cases, payment of a fee.
The licensed program described in this documentation and all licensed
material available for it are provided by IBM under terms of the IBM Customer
Agreement, IBM International
Program License Agreement or any equivalent agreement between us.
Information concerning non-IBM products was obtained from the suppliers
of those products, their published announcements or other publicly
available sources. IBM has not
tested those products and cannot confirm the accuracy of performance,
compatibility or any other claims related to non-IBM products. Questions
on the capabilities of non-IBM products should be addressed to the
suppliers of those products.
All statements regarding IBM's future direction or intent are subject
to change or withdrawal without notice, and represent goals and objectives
only.
Trademarks and service marks
IBM, the IBM logo, and ibm.com® are
trademarks or registered trademarks of International Business Machines
Corporation in the United States, other countries, or both. These
and other IBM trademarked terms
are marked on their first occurrence in this information with the
appropriate symbol (® or ™), indicating US registered or
common law trademarks owned by IBM at
the time this information was published. Such trademarks may also
be registered or common law trademarks in other countries. A complete
and current list of IBM trademarks
is available on the Web at http://www.ibm.com/legal/copytrade.shtml
Microsoft and Windows are trademarks of Microsoft Corporation in the
United States, other countries, or both.
Linux is a trademark of
Linus Torvalds in the United States, other countries, or both.
UNIX is a registered trademark
of The Open Group in the United States and other countries.
Other company, product or service names, may be trademarks or service
marks of others.