Toad for IBM DB2 is available in the following editions: Base, Professional and Xpert. DB Admin Module is an add-on module that provides extended admin functionality and can be added to any Toad edition.
Note: Your Toad for IBM DB2 license key determines the edition and will enable Toad for IBM DB2 functionality accordingly. In many cases, if functionality is disabled within Toad for IBM DB2, you may not have an appropriate license to use it. When Toad is running, you can see which components are licensed by selecting Help | About.
To install Toad
Accept the License Agreement.
Select the products you want to install and click Install.
Note: When installing Toad using Quest Software Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message. Select This program installed correctly to continue installation.
Note: Check Prohibit saving passwords during the installation to prohibit users from saving their passwords in Toad.
Silent installation provides a convenient method for deploying Toad to multiple machines. With some customization, you can also deploy the license key and settings at the same time.
Use a stand-alone installer to perform a silent install. Obtain your installer files at https://support.quest.com/.
Before you can perform a silent installation, the following software must be installed on every computer where you are installing Toad:
Use the executable file to perform a silent install to the default directory (or to a different directory) and to specify options such as logging installation messages.
To perform a silent install using the executable file
For a standard installation with all features enabled, enter the following command:
You can customize MSIEXEC command-line options and overrides for your installation similar to the following command:
“ToadInstaller.exe” /S /Lx “C:\temp\installLog.txt” INSTALLDIR=”Drive:\your_install_path” USERNAME=”some_user” COMPANYNAME=”your_company” ALLUSERS=1
Use the following descriptions to customize the command-line options and overrides for your installation.
The following MSIEXEC command-line options are used in this example:
(Optional) Write installation messages to the specified log file.
Substitute “C:\temp\installLog.txt” in the example with the fully qualified name of the log file. Enclose this value in double quotations. The installation process creates this file if it does not exist. Otherwise, the existing file is overwritten.
You can add additional parameters to the logging option to indicate what type of information to log.
See the log section at http://msdn2.microsoft.com/en-us/library/aa367988.aspx for more information about additional logging parameters.
Specify the full path to a license file, e.g. License="C:\ProgramData\Quest Software\Toad for IBM DB2". Toad for IBM DB2 to use Toad with the desired license.
Toad Default Installation Option Overrides
You can specify the following values to override Toad’s default installation options. Enclose each value in double quotations.
(Optional) Specify the absolute path for the directory in which you want to install Toad. If you do not include this path, the installation program defaults to:
(Optional) Specify one of the following:
Note: If you do not specify this property, the installation program defaults to a per-user installation.
(Optional) Specify the user that intends to use Toad on the target computer.
(Optional) Specify the name of the company that owns this installation.
(Optional) Set in order to prohibit users from saving their passwords in Toad.
|(Optional) Enter a full path to the Options Template that you generated in Tools | Options | General.
Depending on your Toad license type, additional Toad components might be available. See the following sections for information about installing these components:
The Toad for IBM DB2 z/OS components enable you to take full advantage of Toad functionality on your DB2 for z/OS subsystem. If you do not have the z/OS components installed, Toad still provides some basic functionality to manage your DB2 for z/OS subsystems. However, with the z/OS component installed on your DB2 subsystem, you can perform these additional functions in Toad:
The z/OS components should be installed on each subsystem that you wantToad to manage. For a complete description of system requirements and installation instructions for this component, refer the Toad forIBM DB2 z/OS Components Installation Guide.
LUW Remote Script Execution Wizard has been modified to generate scripts that can be executed natively in the DB2 CLP on the database server. This eliminates the need for the Toad for IBM DB2 Agent which is no longer shipped with Toad.
SQL Optimizer for IBM DB2 LUW lets you tune the SQL used in the DDL for triggers, views, or materialized query tables and the SQL included in packages. You can also tune the SQL on which you are working in the Editor. See the SQL Optimizer for IBM DB2 LUW Installation Guide for requirements and installation instructions.
SQL Optimizer for DB2 z/OS lets you tune the SQL used in the DDL for triggers, views, or materialized query tables and the SQL included in packages and plans. You can also tune the SQL on which you are working in the Editor.