Monday, November 18, 2019
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.
Toad for IBM DB2 7.1.2 is a patch release with new features, security enhancements and resolved issues.
In Toad for IBM DB2 7.1 the following new features were implemented:
For this release of Toad for IBM DB2 we have provided internal security adjustments. We have revised a list of third party components in use according to their known and potential vulnerabilities. Toad uses only reliable and safe components by third party vendors. See the list of third party components in Toad for IBM DB2the help file, section About Us | Third Party Components.
Our Toad installers are now based on the Wix Toolset , which improves user experience and performance of the installation process.
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)
8 GB of RAM minimum, 16 GB recommended
Note: The memory required may vary based on the following:
Hard Disk Space
800 MB to install Toad
Note: The disk space required may vary based on the edition of Toad selected for installation.
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
Microsoft® .NET Framework 4.7.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® 11 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 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:
Note: To use Access 2016 64-bit to connect to an Access database in Toad, the Microsoft Access Database Engine is required and might not be included in the Access installation. The engine must match the architecture (bitness) of Toad.
When deploying Toad in a virtualization environment, for best results ensure the system accurately reflects the applicable client hardware and software requirements listed in this document.
Toad has been developed using Microsoft guidelines (see Remote Desktop Services programming guidelines) and can be deployed and operated in virtualization environments such as Citrix XenApp, Microsoft App-V, and VirtualBox.
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—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:
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, 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:
The following is a list of issues addressed and enhancements implemented in this release of Toad for IBM DB2:
Resolved Issues in 7.1.2
|Feature||Resolved Issue / Enhancement||Defect ID|
We have improved work with calculated fields and aggregate values in Dimensional Viewer
Collation property while importing data using Automation script has been modified to improve performance with certain JOINS on Tables
AutoCommit on IBM DB2 connections now works as designed
Publishing a script with different schemas from the same database now works correctly
Resolved Issues in 7.1
|Feature||Resolved Issue / Enhancement||Defect ID|
|Code Completion||Dragging and dropping column names from Object Explorer to Editor now works correctly.||QAT-15117|
|Object Details (DOV)||We fixed an issue in the DB2 z/OS Subsystem - Right-Hand-Side Dynamic Statement Cache tab where a DB2 error was being thrown when a DSC table was selected if that table creator began with an @.||TDB-3943/454799|
|Pivot Grid||Pivot Grid now allows you to use Aggregated data values in a calculated field.||QAT-14558/4415769|
|Query Builder||You now can select LAG and LEAD in the list of functions for calculated fields in Query Builder.||QAT-14252/4438857|
|SQL Editor||Highlighting keyboard shortcuts now work correctly in Editor.||QAT-15111/4542078, 4555409, 4559368, 4564671|