About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Download
Abstract
This document describes how to download IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows, Version 2.2.1, install the client, and run the server-activation program.
Download Description
IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows, Version 2.2.1 includes new features, enhancements, and fixes to the version 2.2.0.2 release. For details about the version 2.2.1 release, see Release Notes.
Before you install Optim Query Tuner for DB2 for Linux, UNIX, and Windows, click the link in the Download package table below and download the following compressed files from IBM Passport Advantage:
- CZPV9ML.zip
- CZPW0ML.zip
- CZPF4ML.zip
- This file contains the installation program for IBM Optim Query Tuner client, Version 2.2.1. Install the Optim Query Tuner client on the client Windows system.
- This file contains the server-activation program for Optim Query Tuner for DB2 for Linux, UNIX, and Windows, Version 2.2.1. Run this program on the database server to activate the product license and enable the Index Advisor stored procedure.
Note: If the license for Optim Query Tuner for DB2 for Linux, UNIX, and Windows Version 2.2 is activated on your database server, you do not need to download this file and activate the current license again.
- This file contains the Quick Start Guide that gets you started with a typical installation of Optim Query Tuner for DB2 for Linux, UNIX, and Windows.
Prerequisites
You need approximately 2.5 GB free space on your client system and 1.5 GB free space on your database server to store and extract the content of the compressed files.
For requirements about hardware and software for the Optim Query Tuner client, Version 2.2.1, see System requirements.
Installation Instructions
To install Optim Query Tuner for DB2 for Linux, UNIX, and Windows:
- On the database server, activate the product license and enable the Index Advisor stored procedure:
- Transfer the CZPW0ML.zip file to the database server and extract the content of this compressed file into a temporary directory.
- Run the installation program for your platform. You can use the installation wizard or the console mode. Optionally, you can also use a response file to install silently. See the "Activating the product license and enabling the Index Advisor stored procedure for Optim Query Tuner for DB2 for Linux, UNIX, and Windows on a database" topic in the information center:
- On the client Windows system, install the Optim Query Tuner client:
- Extract the content of the CZPV9ML.zip file into a temporary directory.
- Install the Optim Query Tuner client. The steps differ depending on whether a previous version or a beta version is installed. See step 2 in the "Roadmap for installing IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows and configuring a DB2 database for query tuning" topic in the information center:
What to do next
You can configure your database for query tuning with the Optim Query Tuner client by following the instructions in the Quick Start Guide.
Download Package
Off
[{"DNLabel":"IBM Optim Query Tuner","DNDate":"10/8/2010","DNLang":"English","DNSize":"1613758464","DNPlat":{"label":"Windows","code":"PF033"},"DNURL":"http://www.ibm.com/software/howtobuy/passportadvantage/pao_customers.htm","DNURL_FTP":" ","DDURL":null}]
[{"Product":{"code":"SS7L89","label":"InfoSphere Optim Query Tuner for DB2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
InfoSphere Optim Query Tuner for DB2 for Linux, UNIX and Windows
Software version:
2.2.1
Operating system(s):
Windows
Document number:
577091
Modified date:
15 June 2018
UID
swg24023064