Quest-TOAD FOR DB2

1.1 Supported Platforms

• Operating Systems
  - Windows Server@ 2008 R2 SP2
  - Windows Server@ 2012
  - Windows Server@ 2012 R2
  - Windows Server@ 2016
  - Windows Server@ 2019
  - Windows@ 7 SP1 (32-bit or 64-bit)
  - Windows@ 8.1 (32-bit or 64-bit)
  - Windows@ 10, version 1809

• Firewall Requirement
  - Windows Server
  a) Port 135 (WMI) to Destination and WMI Random port 49152 - 65535 to Spotlight Client
  b) Spotlight requires the network setting “File and Print Sharing” to be enable
  - Database Monitor

  a) Database Port

• Hardware Require (Minimum)
  - 2 GHz processor (recommended minimum) Platform
  - 4 GB of RAM minimum, 16 GB recommended Memory

• Hard Disk space : 800 MB to install Toad, 162 MB to run Toad

• Microsoft .NET Framework 4.7.1

• Database Client : When connecting to a DB2 database/subsystem, ensure that you have a DB2 Client or IBM Database Data Server Driver installed.
  - Toad supports DB2 Client versions 9.7.6 through 11.1
  - Toad has been tested with the following versions of the DB2 Client: 9.7.6, 9.7.9, 10.1.0, 10.1.2, 10.1.3,
  10.5.0, 10.5.2, 10.5.3, and 11.1.0

• Browser Require
  - Internet Explorer@ 11 or later

• Supports screen : screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

1.2 User Requirements

1. User Requirements to Install Toad

• Only Windows Administrators and Power Users can install Toad.

• If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.

• If a Power User installs Toad, a Restricted User cannot do the following:
  - l Associate file extensions.
  - l View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start
  menu.
  As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place
  the shortcut on their desktop.

2. User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

• A Windows Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to one of these groups, select Start | Control Panel | Administrative Tools | Computer
  Management | System Tools | Local Users and Groups | Groups | DB2ADMNS or DB2USERS.

• A Windows Power User or Restricted User does not have the authority to add or remove DB2 catalog
  entries using the Toad Client Configuration wizard. However, these users can use the Import Profile
  function in the Toad Client Configuration wizard to import catalog entries to Toad.

• To take full advantage of Toad for DB2 LUW functionality, the user ID specified in the Toad connection profile for each DB2 for LUW database connection requires the authorizations listed in the following document: ToadDB2LUWAuthorizations.pdf

• As a minimum requirement to manage a DB2 for z/OS subsystem in Toad, the user ID defined in the
  Toad connection profile for the subsystem must either have SYSADM privileges or SELECT privileges
  on the DB2 catalog tables. For a complete list of authorizations (and corresponding GRANT statements) a user requires to take full advantage of Toad for DB2 z/OS functionality, refer to the following document: ToadDB2zOSAuthorizations.pdf

• To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who
  maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

• (The ability to define RACF, Unix, and Linux groups as Toad Security roles works with DB2 for LUW 9 or later databases and DB2 for z/OS 8 or later subsystems.

• Required user authorities or privileges for each DB2 database you want to monitor

2.1 Install TOAD for DB2

There are several ways to find the installers :

1. Finding Installers : Download product from the Website or Log in Support Portal

2. Run the installer Click run as Administrator , Click Next

3. Click accept the license agreement , Click Next

4. Select “ Toad File Extensions format” , Click Next

Open

5. Check Allow saving passwords to prohibit users from saving their passwords in Toad. Click Next

Open

6. Click Finish and Click Yes for restart the computer.

2.2 Install SQL Optimizer for DB2

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.

To Install SQL Optimizer for DB2 on a Windows machine :

1. Finding Installers : Download product from the Website or Log in Support Portal

2. Run the installer Click run as Administrator , Click Next

3. Click accept the license agreement , Click Next

4. Select Directory Location for install, Click Next

5. Begin installation process, installation complete Click Finish

2.4 Specify Application Data Directory Location

The default location cannot be modified from within the application. Toad provides two methods to change the default location: by using a Registry setting or by using a command switch in a Toad shortcut.

Use the Registry setting method to change the application data directory from Roaming to Local. Use the command switch method to change the location to any new path.

See the following table for default (Roaming) and resulting (Local) directory path.

• To change Toad Application Data directory location using a command-line switch
  You can override the default Application Data directory by running Toad with the command switch:
  Toad.exe --datadir="YourNewDirPath"

To instruct Toad to always use the new directory path, add the command switch and the new directory path to a Toad desktop shortcut. Then use the desktop shortcut when opening Toad.

1. To add the command switch, right-click the Toad shortcut and select Properties.

2. Enter the command switch and add the directory path in quotes (replace "YourNewDirPath" with your
   directory path).