IBM InfoSphere Optim Query Workload Tuner, Version 4.1
Installation Guide
Note
Before using this information and the product it supports, read
the information in Notices.
This edition applies to version 4.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 2013.
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 4.1
Installing IBM®InfoSphere®Optim™ Query Workload Tuner, Version 4.1 installs
two components on your workstation: IBM Data
Studio client, Version 4.1 and a license activation kit for InfoSphereOptim Query Workload Tuner, Version 4.1.
Product components
This section describes
the two product components that you can install.
- IBM Data Studio client,
Version 4.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 features for
any databases on which the full set of features for IBM InfoSphere Optim Query Workload Tuner, Version
4.1 is activated.
Attention: If version 3.2 of the IBM
Data Studio client is installed on your workstation, you cannot update
that installation to version 4.1. If you choose to install version
4.1 into the package group where version 3.2 is installed, IBM Installation
Manager uninstalls version 3.2 and then installs version 4.1.
- A license activation kit for InfoSphere Optim Query Workload Tuner, Version
4.1
- This kit allows you to activate the full set of features for tuning
query workloads and single SQL statements. This activation is required
once only. One person installs the license activation kit together
with the Data Studio client, Version 4.1. Then, that person can activate
the full set of tuning features by connecting to a database or subsystem
through the Data Source Explorer, right-clicking that database or
subsystem, and selecting Analyze and Tune > Activate Full Set of Tuning Features. After the features are activated, they are available
to anyone else who connects to that database or subsystem through
the Data Studio client, Version 4.1.
Your product DVD or the compressed
file that you downloaded from IBM Passport Advantage® or 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
Supported installation scenarios
- Installing IBM Data Studio client, Version 4.1, with or without
a license activation kit, into a new package group
- Installing IBM Data Studio client, Version 4.1, with or without
a license activation kit, into the same package group as an installation
of Optim Database Administrator, Optim Development Studio, the Optim
Query Tuner client, or the Data Studio client, Version 3.2 or earlier.
Note:
In
this scenario, IBM Data Studio client replaces the existing product
that uses the package group. The features in the listed products are
included in IBM Data Studio client, Version 4.1.
- Installing IBM Data Studio client, Version 4.1, with or without
a license activation kit, into the same package group as an already
installed product that is based on Eclipse 4.2
- Installing IBM Data Studio client, Version 4.1 64-bit, with or
without a license activation kit, by using IBM Installation Manager
32-bit
- Installing IBM Data Studio client, Version 4.1 32-bit, with or
without a license activation kit, by using IBM Installation Manager
64-bit
- Installing IBM Data Studio client, Version 4.1 64-bit, with or
without a license activation kit, by using IBM Installation Manager
64-bit
- Installing the license activation kit into an existing installation
of IBM Data Studio client, Version 4.1
Installing InfoSphere Optim Query Workload Tuner by using the
IBM Installation Manager wizard
Use this method of installation when you want to install
the product on a single workstation.
Before you begin
Ensure that your workstation meets the system requirements.
About this task
To learn more about the two components of InfoSphere Optim
Query Workload Tuner that you can install, see Product components for InfoSphere Optim
Query Workload Tuner, Version 4.1.
Procedure
To install InfoSphere Optim Query Workload Tuner, Version
4.1 by using the IBM Installation Manager wizard:
- If IBM Installation Manager is already installed on the
workstation, ensure that it checks automatically for updates to itself.
- Start 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 that you downloaded from IBM Passport Advantage, double-click
the appropriate file for your operating system:
- On 32-bit and 64-bit Windows operating systems: setup.exe
- On 64-bit Windows operating systems if your user ID does not have
administrative privileges: setup_win_nonadmin64.exe
- On 32-bit and 64-bit Linux operating systems: setup
- In the launchpad, select Install Product.
- Specify whether to run an administrative installation or
a non-administrative installation.
- On the Select Packages page of the
wizard, select the package for the Data Studio client, the package
for the license activation kit, or both packages, depending on whether
you plan to install one or both product components. If
IBM Installation Manager is not yet installed on the system, it appears
in the list of packages and is selected by default.
- On the Install Packages page of the
wizard, choose one of the following actions:
- If you are installing the Data Studio client for the first time,
create a new package group.
- If you are installing the license activation kit only into an
existing installation of the Data Studio client, version 4.1, specify
the package group in which the client is located.
- 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, 3.1.1, or 3.2 and the full set of tuning features for that version
is active on the databases or subsystems, you can start the IBM Data
Studio client and start tuning.
Installing InfoSphere Optim Query Workload Tuner silently on
Linux workstations
Use this method of installation when you want to install
the product on multiple Linux workstations.
Procedure
To install silently on multiple Linux workstations:
- Generate
a response file on a Linux workstation.
- Run
the response file on multiple Linux workstations.
Generating response files on Linux workstations
If you want to install the product silently on multiple
Linux workstations, you must first generate a response file.
Before you begin
- If target workstations are running 32-bit Linux, you must generate
the response file on a 32-bit Linux workstation.
- If target workstations are running 64-bit Linux, you must generate
the response file on a 64-bit Linux workstation.
- Ensure that IBM Installation Manager is installed on the workstations
that you use to generate a response file.
Procedure
To generate a response file:
- Ensure that IBM Installation Manager automatically checks
for updates to itself.
- Start 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.
- Record the response file by following the steps
in the topic "Recording a response file with Installation Manager".
After you finish step 2 in that topic and Installation Manager
starts, select File > Preferences in the menu bar. On the Repositories page
of the Preferences window, follow one of these
steps to add the repository or repositories where the installation
media is located.
- If you want to install both the IBM Data Studio client and the
license activation kit, add the location of the diskTag.inf files
for both the IBM Data Studio client, Version 4.1 and the IBM InfoSphere
Optim Query Workload Tuner License Activation Kit, Version 4.1.
- If you want to install only the IBM Data Studio client, add the
location of the diskTag.inf file for the IBM
Data Studio client, Version 4.1.
- If you want to install only the license activation kit because
the IBM Data Studio client, Version 4.1 is already installed on target
machines, add the location of the diskTag.inf file
for the IBM InfoSphere Optim Query Workload Tuner License Activation
Kit, Version 4.1.
The path to the diskTag.inf file
for IBM Data Studio client is:
root_path_of_installation_media/disk1/diskTag.inf
The
path to the diskTag.inf file for the license
activation kit is:
root_path_of_installation_media/oqwt/diskTag.inf
On
the Install Packages page, specify a new package
group.
- Finish the remaining steps in the wizard. When the wizard finishes, the response file is generated
at the location that you specified when you ran the command to generate
the response file.
- If IBM Installation Manager is not installed
on the workstations where you plan to run the response file, modify
the response file by adding information for installing IBM Installation
Manager.
- Open the response file in a text editor.
- Open the repository.xml file for IBM Installation Manager
in a text editor. The path to this file is:
root_path_of_installation_media/disk1/InstallerImage_platform/
.
- In the repository.xml file, copy
the opening <offering> tag. That tag looks
similar to this: <offering id='com.ibm.cic.agent' version='1.6.0.20120831_1216'>
- In the response file, create a new line after the opening <install> tag.
- Paste the copied <offering> tag
at the new line, so that the tag is the first entry after the <install> tag.
- Before the closing angle bracket in the <offering> tag,
type a space and a forward slash.
- In the offering tag, replace the single quotation marks
with double quotation marks.
- Save and close the response file.
What to do next
Transfer the response file to a Linux workstation where you
want to install the product.
- If you generated the response file on a 32-bit Linux workstation,
transfer the file to a 32-bit Linux workstation.
- If you generated the response file on a 64-bit Linux workstation,
transfer the file to a 64-bit Linux workstation.
After you transfer the response file, run
it on the target Linux workstation.
Running response files on Linux workstations to install InfoSphere
Optim Query Workload Tuner
After you generate a response file on a Linux workstation,
you can run that file on multiple Linux workstations to install the
product.
Before you begin
- If you generated the response file on a 32-bit Linux workstation,
you must run the response file on 32-bit Linux workstations.
- If you generated the response file on a 64-bit Linux workstation,
you must run the response file on 64-bit Linux workstations.
- 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 the IBM Installation Manager Kit is
copied to a location on the workstation, if IBM Installation Manager
is not installed on the workstation.
Procedure
To run a response file:
- If IBM Installation Manager is not installed on the target
Linux workstation, follow these steps.
- Change to the InstallerImage_Linux/tools subdirectory
of the IBM Installation Manager Kit.
- Run one of these commands to run the response file:
- If IBM Installation Manager is installed on the target
Linux workstation, follow these steps.
- At a command line, change to the eclipse subdirectory
where IBM Installation Manager is installed.
- If version 1.3.4 or 1.4.2 is installed, run one of these
commands to run the response file:
- If you have administrative rights on the workstation:
./IBMIM --launcher.ini silent-install.ini input response_file_path_and_name
-log log_file_path_and_name
- If you do not have administrative rights on the workstation:
./userinst --launcher.ini silent-install.ini input
response_file_path_and_name -log log_file_path_and_name
- If version 1.4.3 or later is installed, run this command
to run the response file:
./tools/imcl -acceptLicense input response_file_path_and_name
-log log_file_path_and_name
Installing InfoSphere Optim Query Workload Tuner silently
on Windows workstations
Use this method of installation when you want to install
the product on multiple Windows workstations.
Procedure
To install silently on multiple Windows workstations:
- Generate a response file on a Windows workstation.
- Run
the response file on multiple Windows workstations.
Generating response files on Windows workstations
If you want to install the product silently on multiple Windows workstations, you must
first generate a response file.
Before you begin
- If target workstations are running 32-bit Windows, you must generate the response file
on a 32-bit Windows workstation.
- If target workstations are running 64-bit Windows, you can generate the response file
on a 32-bit or a 64-bit Windows workstation.
Procedure
To generate a response file:
- Ensure that IBM Installation
Manager automatically checks for updates to itself.
- Start 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.
- Record the response file by following the steps
in the topic "Recording a response file with Installation Manager".
After you finish step 2 in that topic and Installation Manager
starts, select File > Preferences in the menu bar. On the Repositories page
of the Preferences window, follow one of these
steps to add the repository or repositories where the installation
media is located.
- If you want to install both the IBM Data Studio client and the
license activation kit, add the location of the diskTag.inf files
for both the IBM Data Studio client, Version 4.1 and the IBM InfoSphere
Optim Query Workload Tuner License Activation Kit, Version 4.1.
- If you want to install only the IBM Data Studio client, add the
location of the diskTag.inf file for the IBM
Data Studio client, Version 4.1.
- If you want to install only the license activation kit because
the IBM Data Studio client, Version 4.1 is already installed on target
machines, add the location of the diskTag.inf file
for the IBM InfoSphere Optim Query Workload Tuner License Activation
Kit, Version 4.1.
The path to the diskTag.inf file
for IBM Data Studio client is:
root_path_of_installation_media/disk1/diskTag.inf
The
path to the diskTag.inf file for the license
activation kit is:
root_path_of_installation_media/oqwt/diskTag.inf
On
the Install Packages page, specify a new package
group.
- Finish the remaining steps in the wizard. When the wizard finishes, the response file is generated
at the location that you specified when you ran the command to generate
the response file.
- If IBM Installation Manager is not installed
on the workstations where you plan to run the response file, modify
the response file by adding information for installing IBM Installation
Manager.
- Open the response file in a text editor.
- Open the repository.xml file for IBM Installation Manager
in a text editor. The path to this file is:
root_path_of_installation_media/disk1/InstallerImage_platform/
.
- In the repository.xml file, copy
the opening <offering> tag. That tag looks
similar to this: <offering id='com.ibm.cic.agent' version='1.6.0.20120831_1216'>
- In the response file, create a new line after the opening <install> tag.
- Paste the copied <offering> tag
at the new line, so that the tag is the first entry after the <install> tag.
- Before the closing angle bracket in the <offering> tag,
type a space and a forward slash.
- In the offering tag, replace the single quotation marks
with double quotation marks.
- Save and close the response file.
What to do next
Transfer the response file to a Windows workstation where you want to install
the product.
- If you generated the response file on a 32-bit Windows workstation, transfer the file to
either a 32-bit or a 64-bit Windows workstation.
- If you generated the response file on a 64-bit Windows workstation, transfer the file to
a 64-bit Windows workstation.
After you transfer the response file, run
it on the target Windows workstation.
Running response files on Windows workstations to install InfoSphere
Optim Query Workload Tuner
After you generate a response file on a Windows workstation,
you can run that file on multiple Windows workstations to install
the product.
Before you begin
- If you generated the response file on a 32-bit Windows workstation,
you can run the response file on 32-bit or 64-bit Windows workstations.
- If you generated the response file on a 64-bit Windows workstation,
you must run the response file on 64-bit Windows workstations.
- 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 the IBM Installation Manager Kit is
copied to a location on the workstation, if IBM Installation Manager
is not installed on the workstation.
Procedure
To run a response file:
- If IBM Installation Manager is not installed on the target
Windows workstation, follow these steps.
- Change to the InstallerImage_platform\tools subdirectory
of the IBM Installation Manager Kit.
- Run one of these commands to run the response file:
- If IBM Installation Manager is installed on the target
Windows workstation, follow these steps.
- At a command line, change to the eclipse subdirectory
where IBM Installation Manager is installed.
- If version 1.3.4 or 1.4.2 is installed, run one of these
commands to run the response file:
- If you have administrative rights on the workstation:
IBMIMc.exe --launcher.ini silent-install.ini input
response_file_path_and_name -log log_file_path_and_name
- If you do not have administrative rights on the workstation:
userinstc.exe --launcher.ini silent-install.ini input
response_file_path_and_name -log log_file_path_and_name
- If version 1.4.3 or later is installed, run this command
to run the response file:
imcl.exe -acceptLicense input response_file_path_and_name
-log log_file_path_and_name
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.