Chatta subito con l'assistenza
Chat con il supporto

Toad for DB2 7.2 - Release Notes

Toad for IBM DB2 7.2

Toad for IBM DB2 7.2.x

Release Notes

Friday, May 22, 2020

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 IBM DB2 7.2 is a minor release with new features, security enhancements, and resolved issues.

New Features

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

Database Support

IBM DB2 LUW 11.5 is now supported

You now can use Toad to connect and use new features of IBM DB2 LUW 11.5 including external tables.

Pivot Grid

We added new options for Group By functions. Right-click a column header and Select from the available Group By options according to your data.

Now you can also summarize by ListAgg function.


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

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

8 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® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

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

Windows® 10

.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.5.

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

Recommended maximum DPI settings for Toad are 125%. It is possible to use Toad up to 200% but some dialog windows will not be completely usable anymore.

Maximum tested resolution for Toad is 3800 x 2160 px.

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.7, 10.1, 10.5, 10.5.0.5, 11.1, 11.5

IBM DB2 for z/OS 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

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

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

Automation Publishing wizard now sets permissions of objects correctly in Automation script QAT-15458/4603555
Code Completion Dragging and dropping column names from Object Explorer to Editor now works correctly. QAT-15117
Data Compare & Sync We have implemented a new performance option for exporting to Excel. Enable it in Tools | Options | Data Compare | General 15514/1713
Data Compare & Sync An issue when Data Compare displayed incorrect results has been fixed 15603
Data Compare & Sync Error during Data Compare with a Local Storage table has been fixed 15602
Data Compare & Sync An error when not all data rows were returned in Data Compare has been fixed 1663/4556801
General An error when parsing a TIC query with group_concat() function has been fixed 2593/4666051
General Users that execute Automation script are not added to OS Admin group on server anymore 2509/4197716
General Behavior of Toad at high resolutions since patch version 5.1.2 has been improved 2320/4620661, 4623009, 4685386, 4685115 
General

Collation property while importing data using Automation script has been modified to improve performance with certain JOINS on Tables

QAT-15314/4572415
Import Wizard Save Log option is now saved in Import Templates 2281/4628189 
Import Wizard It is now possible to import blank values 2293/4587201
Installation Opening associated files with SQL extension now works correctly with Toad  
Installation

You now can deploy user settings during silent installation of Toad. Enter a full path to the Options Template that you generated in Tools | Options | General for a silent installation.

1820/4618673 
Job Management An issue with migration of a Task Manager item using a password has been fixed QAT-15368/4524397
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
Options Up and Down arrows now work correctly in Tools | Options | Explorer | Objects QAT-15457/2221/2175
Pivot Grid We have added options for Date Grouping and Formatting in Pivot Grid QAT-15414/4556962
Pivot Grid We improved backward compatibility of Pivot Grid 2688/4593313 
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field. QAT-14558/4415769
Query Builder We improved attachment of Calculated fields in Query Builder to correct columns 2627/4650476 
Query Builder Several issues when using Where clause in Query Builder have been fixed 2292/4602617
Query Builder An issue with WHERE clauses has been fixed 1653/15456/4555521
Query Builder Adding additional AND clause in query tab and then visualizing does not create a Global Where clause 1371
Query Builder You now can select LAG and LEAD in the list of functions for calculated fields in Query Builder QAT-14252/4438857
Schema Compare Now you can ignore differences in constraint names when one of the names is system generated TSS-1525/4198363
Script Generation Statistics profile is now preserved when you drop and recreate a table TDB-3953
SQL Editor

AutoCommit on IBM DB2 connections now works as designed

TDB-3950/ 4576728
SQL Editor Highlighting keyboard shortcuts now work correctly in Editor. QAT-15111/4542078,   4555409,  4559368,   4564671  
Team Server

Publishing a script with different schemas from the same database now works correctly

QAT-15319/4534571
Strumenti self-service
Knowledge Base
Notifiche e avvisi
Supporto prodotti
Download di software
Documentazione tecnica
Forum utente
Esercitazioni video
Feed RSS
Contatti
Richiedi assistenza sulle licenze
Supporto tecnico
Visualizza tutto
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione