Chat now with support
Chat with Support

Toad for DB2 6.5 - Release Notes

Toad™ for IBM® DB2® 6.5

Toad® for IBM® DB2® 6.5

Release Notes

Tuesday, November 14, 2017

About Toad® for IBM® DB2®

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management, and develop SQL more efficiently.

Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.

New Features

New Features

In Toad® for IBM® DB2® 6.5 the following new features were implemented:

General Features

Object Details

Object Overview Tab

  • Display information from several Object Details tabs at once
  • The new object Overview tab allows you to display any other tab at once
  • Add, remove and replace panes and add formatting aids such as labels and separators to further organize your Overview
  • Click Customize Layout to edit layout and add or remove data from more Object Details tabs

Grants Tab

  • A new Grants tab that displays any CREATE ROLE and GRANT ROLE statements for a selected role
  • Double-click a role in Object Explorer and select Grants

Compare Object

  • Check Format object body before comparing in step 2 of Compare Object to make it easier to spot any differences


  • Now you can scroll your Live Query widget to left and right to display more columns as needed
  • Both LUW and z/OS dashboards can now be shared between connections
  • Click Dashboard | My Dashboards and select Clone to share a dashboard

LUW Specific Features

User Privileges

  • Cataloged global temporary tables are now displayed in User Privileges Editor
  • Right-click a user in Object Explorer and select Alter User
  • Select CGT Table to edit privileges for cataloged global temporary tables

LUW Utilities

  • INPLACE clause is supported for LUW REORG

Space Management

  • A new Object Detail tab is available, which lists unused indexes and their last used date
  • Right-click an index in Object Explorer and select Space Management | Identify Exceptions
  • When working with Batch Analysis within Automation a new checkbox is available
  • Check Unused Index Report to generate report about unused indexes in your database


  • Right-click a partitioned table in Object Explorer and select Space Management | Analyze Table Partitions
  • A new option ADMIN_MOVE_TABLE is available for Data Preservation Options

z/OS Specific Features

Partitioned Data Set Support

  • Now you can send any scripts to your Partitioned Data Set members or load any scripts from your PDS members into SQL Editor
  • Click Save SQL script to a PDS member or Open SQL script from a PDS member in any SQL Editor.

z/OS Utilities

  • A new Object Details editor is available for z/OS Report utility
  • Right-click a tablespace or an index in Object Explorer and select Utilities | Report
  • New Object Details editors are available for z/OS Modify Recovery and Modify Statistics utilities
  • Right-click a tablespace in Object Explorer and select Utilities | Modify Recovery/Statistics

Compare Object

  • New Advanced Option is available, check Generate DEFER for indexes to generate DEFER YES clause for indexes


See Resolved Issues for more enhancements and resolved issues in this release of Toad® for IBM® DB2®.

Learn More

Get the latest product information, find helpful resources, and join a discussion with the Toad® for IBM® DB2® team and other community members. Join the Toad® for IBM® DB2® community at

System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Requirement Details


2 GHz processor (recommended minimum)


4 GB of RAM minimum, 16 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

162 MB to run Toad

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Vista® Service Pack 2 (32-bit or 64-bit)

Windows Server® 2008 Service Pack 2 (32-bit or 64-bit)

Windows Server® 2008 R2 Service Pack 1 (64-bit)

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows® 7 (32-bit or 64-bit)

Windows® 8 (32-bit or 64-bit)

Windows® 8.1 (32-bit or 64-bit)

Windows® 10

.NET Framework

Microsoft® .NET Framework 4.5.1

Database Client

When connecting to a DB2 database/subsystem, ensure that you have a DB2 Client or IBM 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.

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 7.0 or later


Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Requirement Details

Database Server

IBM DB2 for LUW 9.5, 9.7, 10.1, 10.5,, 11.1

IBM DB2 for z/OS 9, 10, 11, 12

Note: Toad may support IBM DB2 Express and SWE in addition to listed above servers, but note that no testing was performed on it.

Note: Windows 8, 10 and Windows Server 2012 require the following Fix Pack in order to ensure registration of DLLs in Global Assembly Cache:

IBM DB2 LUW 10.5 Fix Pack 4
IBM DB2 LUW 10.1 Fix Pack 4
IBM DB2 LUW 9.7 Fix Pack 10

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

Desktop Virtualization (VDI)

Toad has been tested with vWorkspace™ 7.6 running on Windows Server 2008 R2 64-bit.

Note: Toad may work in virtualization environments other than the ones in which it was tested.

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

Note: The following exceptions exist for Power Users:

  • A Power User cannot install Toad on a computer running Windows Vista Enterprise. This is a Windows limitation because Vista does not support Power User mode.
  • A Power User can install Toad for IBM DB2 as long as this user belongs to the DB2ADMNS or DBUSERS group.

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:

  • Associate file extensions.
  • 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.

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 Vista user must be either an administrator or a standard user that belongs to Vista Administrators group. Additionally, to enable full functionality in Toad for IBM DB2 when Vista’s User Access Control security feature is turned on, the standard user must run Toad for IBM DB2 as an administrator. (Right-click the Toad for IBM DB2 icon on the Vista desktop and select Run as administrator.)

  • A Windows Power User or Restricted User does not have the authority to add or remove DB2 catalog entries using the Toad for IBM DB2 Client Configuration wizard. However, these users can use the Import Profile function in the Toad for IBM DB2 Client Configuration wizard to import catalog entries to Toad for IBM DB2.
  • 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:

    Toad IBM DB2 LUW Authorizations Spreadsheet

  • As a minimum requirement to manage a DB2 for z/OS subsystem in Toad for IBM DB2, the user ID defined in the Toad for IBM DB2 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:

    Toad IBM DB2 z/OS Authorizations Document

  • 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.
  • For information about defining a RACF, Unix, or Linux group as a Toad Security role, see the About Setting Up Toad Security topic in the Toad online help. This topic explains how to add the Toad Security icons to your toolbar and how to define Toad Security roles that apply to your current connection. (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.)

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad® for IBM® DB2®.

Feature Resolved Issue Defect ID
Compare Object New option that allows formatting of body of object prior to comparison was added. 3109
Triggers are now generated in the order they were applied. 2590/3186073-1
A new option Generate DEFER for indexes is available in Advanced Options for Compare Object. 3371
Connection Manager A mouse pointer is now placed correctly in Need more information to connect dialog. 3370/4059503-1
Database Explorer System.InvalidCastException on right-click the name column has been fixed. 3408/4083232-1
Display of Database parameters for IBM DB2 9.7 now works correctly. 3367/4053481-1
Dashboard Live Query widget is now scrollable. 3281
Explain Plan Host variables, e.g. :H:H are now resolved during Explain Plan. 3398
General Support for Windows Server 2016. 3223/3876186-1
LDAP support for 64-bit Toad now works correctly. 3443/4092059-1
Installation An option to prohibit users from saving their passwords has been added. Select “Prohibit saving passwords” during the installation. 1710
Migration Now you can select between Export/Load and Export/Import (IXF files) in Options | Database | DB2 | Advanced Admin. 3228/3868584-1
Object Details (DOV) Toad now generates GRANT statements under "Edit Table Privileges" correctly. 3405/4079762-1
Display of WLM SYSDEFAULTSUBCLASS entries Properties tab has been improved. 3369/4057682-1
Some deprecated IBM DB2 LUW 9.7 features have been replaced by current features. 3430/4095678-1
WLM SYSDEFAULTSUBCLASS entries are now displayed correctly on Properties tab. 3369/4057682-1
Object Editor (DOE) Support for granting SECADM to a GROUP. 3372/4060287-1
Query Builder An option to specify WITH UR clause has been added to Query Builder. Check Uncommitted Read. 2228
Script Generation Toad now uses the correct statement delimiter in extended alters. 3374
SQL Editor Set current query optimization statement is now considered when generating an explain plan. 2654/3219434-1
Toad now handles procedures starting with “@” correctly.


Script Statement Delimiter is now used when executing a procedure via right-click menu from Object Explorer. Set the delimiter in Tools | Options | Database | DB2 | General. 3311
Now you can send any scripts to your PDS members. Click Save SQL script to a PDS member in SQL Editor. 3341
Now you can load any scripts from your PDS members into SQL Editor. Click Open SQL script from a PDS member in SQL Editor. 3343
Cancelling DB2 queries in SQL Editor Toad now works correctly. 3425/4087985-1
z/OS Utilities Errors occuring in QPDSNAT are now displayed correctly. 3105/3661545-1
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating