Chat now with support
Chat with Support

Toad for DB2 7.0 - Release Notes

Toad for IBM DB2 7.0

Toad for IBM DB2 7.0.x

Release Notes

Thursday, July 25, 2019

Contents

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.

Toad for DB2 7.0.7 is a patch release with new enhancements and resolved issues.

New Features

New Features

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

General Features

Connection Manager

  • Toad now allows users to specify their own custom connection string when creating connection profiles SQL Editor

SQL Editor

  • Toad now supports Nicknames in SQL Editor - Code Completion feature

z/OS Specific Features

Automation

  • A new "z/OS RTS Analysis" automation database activity has been added to report objects that might be in need of requiring a Reorg, Copy, or Runstats

DB2 z/OS Dashboard

  • A new "Real Time Statistics" dashboard widget for DB2 z/OS connections has been added to quickly identify top objects that might be in need of requiring a Reorg, Copy, or Runstats

Data Grid

  • Toad now supports viewing PDFs stored in BLOB columns for tables defined on DB2 for z/OS. A 'PDF' tab in the column cell editor has been added for this support

DB2 z/OS Database Explorer

  • For DB2 z/OS tables, indexes and tablespaces Toad now displays current and historical object statistics on the Stats History tab. With these new features you can easily see how statistic data has changed over time for your objects

DB2 z/OS – Commands

  • Toad now supports ACCESS DATABASE command. You can invoke the command dialog to generated and execute that command via right-click on any z/OS tablespace and selecting Commands | Access database

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 Toad World.

System Requirements

System Requirements

Client Requirements

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

Requirement Details

Platform

2 GHz processor (recommended minimum)

Memory

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

800 MB to install Toad

162 MB to run Toad

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

Operating System

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

.NET Framework

Microsoft® .NET Framework 4.7.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® 11 or later

Screen

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, 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:

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

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.

Virtualization Support

Requirement Details
Application Virtualization

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.

Install Toad on Citrix® Systems

Server Virtualization

Toad has been tested with the following:

  • Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
  • Oracle VM 2.2 running on Windows 2008 32-bit with Oracle 11gR2

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 can install Toad 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—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 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.xls

  • 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.doc

  • 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

Resolved Issues and Enhancements

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

Resolved Issues in 7.0.7

Feature Resolved Issue / Enhancement Defect ID
General Support bundle now generates correctly. QAT-14988
Object Details (DOV) Several LUW Database Right-hand-side tabs have been re-written to access DB2 LUW Monitoring data via SQL which will allow those to work in Data Server Driver environments and with connection string connection profiles. Those include the Database Applications tab and the Monitor tab. TDB-3915
Script Generation Generating INSERT statements now works instantly even for tables with large numbers of rows. TSS-1663/4512804
Pivot Grid Pivot Grid column subtotals can now be formatted. QAT-14608
Default subtotal summary type was changed to SUM for string values in Pivot Grid. QAT-14837
There is an new option to show aggregate total values for row categories that only have one value. The default is to not display totals when there is only one value. QAT-14998
It is now possible to display subtotals for single values. Click Set pivot grid properties on Pivot Grid toolbar to enable. QAT-14998

Resolved Issues in 7.0.6

Feature Resolved Issue / Enhancement Defect ID
Automation An issue when Excel spreadsheet exported during Automation was not displayed is now fixed. QAT-14819/4498499
Installation Users should be able to deploy license keys during installation. This was broken in Toad Data Point 5.0 and is now fixed. QAT-14834/

4510329,

4516827,

4516600

Pivot Grid A scroll bar has been added to the row area in Pivot Grid. QAT-14705
Query Builder

Vertical scroll bar is now displayed in Cross-Connection Query Mode of Query Builder.

QAT-14749
Query Builder

A Group By button for aggregated functions has been added to Query Builder.

QAT-14609

 

Resolved Issues in 7.0.5

There were no resolved issues in this version of Toad for IBM DB2.

Resolved Issues in 7.0.4

Feature Resolved Issue / Enhancement Defect ID
Data Generator We have enhanced the DB2 Data Generator feature to include more data generation options including using a set of templates and allowing user to specify their own templates in use for generating data. TDB-3894
Migration We fixed an issue that might have occurred during object compare script generation - where several export temporary files - used for data migration and data preservation could have been generated with the same names. TDB-3907/4470153
SQL Editor Users can now select the directory to serialize large results sets. The option is located under Database | Script results QAT-14377

Resolved Issues in 7.0.3

Feature Resolved Issue / Enhancement Defect ID
Automation Usage connection from parent activity has been reworked. A new option From parent has been added which indicates whether the currently used connection should recursively search for parents QAT-13279
Object Editor (DOE) Toad added support for the BOOLEAN column datatype which was introduced in DB2 LUW 11.1.3 TDB-3889

Resolved Issues in 7.0.2

Feature Resolved Issue / Enhancement Defect ID
Automation Error when .xlsm file could not be exported using Automation script has been fixed QAT-14201
Connection Manager Toad will now correctly prompt for passwords in Connections TDB-3861
Dashboard We addressed a performance issue in the Dashboard feature to reduce the number of SQL queries to populate widget values TDB-3876
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field QAT-14074
SQL Editor New option in Tools | Options | Editor | Tools | Auto highlight selected word enables auto highlighting of selected words TSS-1606

Resolved Issues in 7.0.1

Feature Resolved Issue / Enhancement Defect ID
Automation Automation exception when comparing objects with no report file has been fixed TDB-3843
Data Compare & Sync Error when data cannot be filtered has been fixed QAT-14057
Import Wizard Toad now handles hidden columns within the Import Wizard TDB-3648
Pivot Grid Pivot Grid now supports Top N rows so one can sort and filter for top N values of pivoted data QAT-12434
Query Builder Corrected issue in Query Builder to reverse engineer SQL that contained a UNION and where condition QAT-13812
Query Builder Prior to executing mixed case aliases, the Query Builder would change to upper case causing the execution to fail QAT-13581
Space Management We fixed an issue in the DB2 z/OS Real Time Advisor feature where an exception might have been thrown when certain percentage computations were very large values TDB-3857

Resolved Issues in 7.0

Feature Resolved Issue Defect ID
Automation A new "z/OS RTS Analysis" automation database activity has been added to report objects that might be in need of requiring a Reorg, Copy, or Runstats TDB-3569
We fixed an issue in the Compare Objects - Automation activity - where an exception was being thrown when a report file was not specified TDB-3843
Compare Object We addressed the issue where running Object Compare with the "Format object body before comparing" option selected could cause Toad to hang TDB-3574/4184774
Connection Manager When four or more database profile connections are set to "open at startup" Toad displayed an intermittent error can stating that the Data Server Driver is in error. This has now been addressed TDB-3554/4165781
We fixed the issue where the Connection Manager filtering feature stopped working after connecting to a database TDB-3668/4298525
Data Compare & Sync When generating the PDF comparison report file, we fixed the issue where the duration to generate the report took a very long time and the report was incomplete TDB-3657/4222452
Data Grid Toad now supports viewing PDF's stored in BLOB columns for tables defined on DB2 for z/OS. A 'pdf' tab in the column cell editor has been added for this support TDB-3542
Specifying a custom Time format could cause Toad to throw an exception. This issue has been addressed TDB-3520
Database Explorer On the Security tab, Toad will now display Users that only have been granted explicit Role permissions TDB-3634/4178936
Import Wizard Toad now handles tables with hidden columns within Import Wizard TDB-3648/4255762
Explain Plan Toad now supports host variables formatted such as :H:H in plan/package statements on the Access Path tab TDB-3398
We fixed the issue where Explain plans were not showing for SQL statements with Host variables inside packages TDB-2659/3220331
Export Wizard We fixed an issue that occurred when sending a result set to Export Wizard when a host variable was used in the query creating the result set. Toad now successfully generates the export file. TDB-3783/4371810
Object Details (DOV) For DB2 z/OS Tables, Indexes and Tablespaces Toad now displays current and historical object statistics on the Stats History tab. With these new features you can easily see how statistic data has changed over time for your objects TDB-3422
Real Time Statistics We fixed an issue in the DB2 z/OS Real Time Advisor feature where an exception might have been thrown when certain percentage computations were very large values TDB-3857/4404706
Script Generation When generating scripts containing multiple Triggers (for example for Object Alters or in Object Compare), Toad was not generating the Trigger DDL in the order in which existing Triggers were created. This has now been addressed TDB-3560
On z/OS, scripted dataset template statements were missing the CYL or TRK keywords. This has now been addressed TDB-3561
Toad now correctly scripts trigger body contents when there are whitespace characters at the end of lines within the body TDB-3630/4214958
We fixed an issue, when during an LUW table extended alter, GRANT statements were not always getting re-generated in the alteration script TDB-3684/4313758
Space Calculator We fixed an issue in the LUW Space Calculator where the Total Size and Used Size were not always displaying accurate values TDB-3754/4357765
SQL Editor Toad now supports Nicknames in the SQL Editor - Code Completion feature TDB-3519/4144694
Toad now supports host variables with spaces after a leading colon (like : HOSTVAR) on the Explain tab and and for execution within the Editor TDB-2674/3222711
We fixed an issue that occurred when executing a SQL statement with a host variable in the SQL Editor. If the query returned more rows than the 'Number of rows to initially fetch' editor Options value, when scrolling the result set, the user could obtain a DB2 CLI0100E error TDB-3780
SQL Recall The SQL Recall feature can now be disabled by setting the SQL Recall "Number of statements to display" option to zero TDB-3543
z/OS Commands Toad now supports the ACCESS DATABASE command. You can invoke the command dialog to generated and execute that command via right-click on any z/OS tablespace and selecting Commands | Access database TDB-3551
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents