Tuesday, November 14, 2017
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.
In Toad® for IBM® DB2® 6.5 the following new features were implemented:
See Resolved Issues for more enhancements and resolved issues in this release of Toad® for IBM® DB2®.
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
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
2 GHz processor (recommended minimum)
4 GB of RAM minimum, 16 GB recommended
Note: The memory required may vary based on the following:
Hard Disk Space
Note: The disk space required may vary based on the edition of Toad selected for installation.
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)
Microsoft® .NET Framework 4.5.1
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.
Microsoft® Internet Explorer® 7.0 or later
Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
IBM DB2 for LUW 9.5, 9.7, 10.1, 10.5, 10.5.0.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:
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.
Only Windows Administrators and Power Users can install Toad.
Note: The following exceptions exist for Power Users:
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:
The following describes the requirements and restrictions for users who launch and run Toad:
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.)
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:
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:
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|