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.

Contents

Installing IBM InfoSphere Optim Query Workload Tuner, Version 4.1
Installing InfoSphere Optim Query Workload Tuner by using the IBM Installation Manager wizard
Installing InfoSphere Optim Query Workload Tuner silently on Linux workstations
Generating response files on Linux workstations
Running response files on Linux workstations to install InfoSphere Optim Query Workload Tuner
Installing InfoSphere Optim Query Workload Tuner silently on Windows workstations
Generating response files on Windows workstations
Running response files on Windows workstations to install InfoSphere Optim Query Workload Tuner
Notices
Trademarks and service marks

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:

Supported installation scenarios

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:

  1. If IBM Installation Manager is already installed on the workstation, ensure that it checks automatically for updates to itself.
    1. Start IBM Installation Manager.
    2. Select File > Preferences.
    3. In the Preferences window, select Updates.
    4. On the Updates page, select the option Search for Installation Manager updates. Then, click OK.
    5. Close IBM Installation Manager.
  2. 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:
  3. In the launchpad, select Install Product.
  4. Specify whether to run an administrative installation or a non-administrative installation.
  5. 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.
  6. On the Install Packages page of the wizard, choose one of the following actions:
  7. 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:

  1. Generate a response file on a Linux workstation.
  2. 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

Procedure

To generate a response file:

  1. Ensure that IBM Installation Manager automatically checks for updates to itself.
    1. Start IBM Installation Manager.
    2. Select File > Preferences.
    3. In the Preferences window, select Updates.
    4. On the Updates page, select the option Search for Installation Manager updates. Then, click OK.
    5. Close IBM Installation Manager.
  2. 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.

    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.

  3. 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.
  4. 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.
    1. Open the response file in a text editor.
    2. 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/
      .
    3. 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'>
    4. In the response file, create a new line after the opening <install> tag.
    5. Paste the copied <offering> tag at the new line, so that the tag is the first entry after the <install> tag.
    6. Before the closing angle bracket in the <offering> tag, type a space and a forward slash.
    7. In the offering tag, replace the single quotation marks with double quotation marks.
    8. 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.

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

Procedure

To run a response file:

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:

  1. Generate a response file on a Windows workstation.
  2. 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

Procedure

To generate a response file:

  1. Ensure that IBM Installation Manager automatically checks for updates to itself.
    1. Start IBM Installation Manager.
    2. Select File > Preferences.
    3. In the Preferences window, select Updates.
    4. On the Updates page, select the option Search for Installation Manager updates. Then, click OK.
    5. Close IBM Installation Manager.
  2. 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.

    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.

  3. 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.
  4. 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.
    1. Open the response file in a text editor.
    2. 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/
      .
    3. 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'>
    4. In the response file, create a new line after the opening <install> tag.
    5. Paste the copied <offering> tag at the new line, so that the tag is the first entry after the <install> tag.
    6. Before the closing angle bracket in the <offering> tag, type a space and a forward slash.
    7. In the offering tag, replace the single quotation marks with double quotation marks.
    8. 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.

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

Procedure

To run a response file:

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.