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 license 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® 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
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:

  1. Ensure that IBM Installation Manager checks automatically for updates to itself.
    1. Launch 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. Generate a response file:
    1. 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
    2. 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
    3. In IBM Installation Manager, select File > Preferences.
    4. 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
    5. In the main screen of IBM Installation Manager, click Install.
    6. 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.
    7. Finish the remaining steps in the wizard.
    The response file is generated at the location that you specified when you ran the command.
  3. 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.
  4. Ensure that IBM Installation Manager checks automatically for updates to itself.
    1. Launch 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.
  5. Perform the silent installation.
    1. 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
    2. 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.


Feedback