Chat now with support
Chat with Support

Toad for DB2 6.3 - Release Notes

Release Notes

Toad™ for IBM® DB2® 6.3

Toad® for IBM® DB2® 6.3

Release Notes

(Click here for previous versions)

Friday, August 4, 2017

Contents

About Toad® for IBM® DB2®

New Features

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Product Licensing

Globalization

Getting Started

For More Information

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.3 the following new features were implemented:

General Features

Toad is now 64-bit!

  • Toad® for IBM® DB2® is now available in both 32 and 64 bit versions
  • 64-bit version allows you to perform your DB activities more quickly and seamlessly
  • However a 64-bit version of Toad requires 64-bit IBM DB2 drivers

Support for Microsoft® Windows® 10

  • Microsoft Windows 10 is now fully tested and supported
  • See System Requirements for more information on supported OSs

Data Compare Enhancements

Data Compare to files

  • Click Tools | Compare | Data Compare to launch Data Compare Wizard
  • Select Excel | CSV | Access to start Data Compare with a file

Integration of Toad World Sign-in

  • You now can easily register and sign in to Toad World directly in the Toad
  • Use Toad World to access various information articles and training videos about Toad, ask question in our forums or give the developers feedback about Toad® for IBM® DB2®

Support for IBM Data Server Driver

  • Toad® for IBM® DB2® now supports IBM Data Server Driver
  • Now you do not need a default IBM DB2 client and can make use of DSD Package instead
  • You can import and DSD configuration files easily by clicking Create Toad connection profiles for all DB2 databases in the DB2 client catalog or driver configuration file that Toad is using

Custom Connection String

  • You now can connect to a DB2 database by directly specifying the host, port and database name like in IBM Data Server Driver environment
  • When connected via a connection string no DB2 instance is created
  • Click New connection and then select Connection string to enter the custom connection string

New Videos Button

  • You can now easily access product and training videos by clicking a new button Videos from the Toad toolbar

Integration of Knowledge Base and Toad World Search

  • Quickly look up errors on our Support site or directly in Toad

  • Use the Search field to search our knowledge base and Toad World at the same time

Other Enhancements

  • All property grids can now be sorted
  • Right-click any grid in Object Editors and select Sort Alphabetically

  • You can track your grant statements together with script in Version Control
  • Check the option in Options | Version Control | General

  • You can now turn off popup information for objects in SQL Editor
  • Uncheck Show information pop-ups for Objects in Options | Editor | Tools

Compare Object Enhancements

  • A new Advanced option in Compare Object allows you to ignore String Units

Git Support in Version Control

  • Toad now supports Git

LUW Specific Features

LUW Dashboard

  • The following new snippets were implemented for Toad:

Lock Waits - Displays Lock Waits from the active connection

Tablespace Max. Size - Shows percentage of maximum tablespace size for a given connection

System General - Displays detailed DB2 system information

Support for IBM DB2 LUW 11

  • Toad now supports connection to and various features of the latest IBM DB2 11
  • Toad now includes automatic configuration parameters during compare of DB and DBM parameters

New Built-in Aggregate & Scalar Functions in Snippets

  • Toad offers new Aggregate and Datetime Scalar Functions in Code Snippets

Support for New options for ADMIN_MOVE_TABLE

  • New options Report and Terminate are now supported

Support for CHAR(255) Columns

  • Table Object Editors now support Character Length 255

Support for the Latest DB2 Utilities Changes

  • REORG, RUNSTATS syntax changes
  • Support for STOSPACE Utility

New Options for Backup Database

  • Backup Database now supports No Tablespace option

New CREATE FUNCTION Statement for User-Defined Aggregate Functions

  • User Defined Aggregate Functions are now supported by Toad® for IBM® DB2®

Support for New DBM and DB Configuration Parameters

Database configuration parameters

APPLHEAPSZ

CATALOGCACHE_SZ

dbheap

rec_his_retentn

stat_heap_sz

stmheap

Database manager configuration parameters

mon_heap_sz

INSTANCE_MEMORY

Batch Analysis

  • Batch Analysis can now be easily launched as a part of Toad Automation

Audit Policy

  • Objects that are associated with Audit Policies are now displayed on the Audit Policy’s Dependencies tab in Object Details Editor
  • You can now right-click an Audit Policy and associate objects to Audit Policies
  • Database Map now supports Audit Policies

Object Explorer Enhancements

  • You now can easily convert a row organized table to a column organized table
  • Right-click and select Convert Table to Column Organized

z/OS Specific Features

Support for IBM DB2 z/OS 12

Toad for IBM DB2 now supports connection to and various features of the latest IBM DB2 11:

  • Utility execution via new DSNTUILV procedure
  • New syntax for CREATE\ALTER TABLE
  • New syntax for CREATE\ALTER TABLESPACE
  • New TRANSFER OWNERSHIP support
  • Support the ability to define a global variable based on array type
  • Support for new definitions of explain and dynamic statement cache tables
  • Bind package Editor now supports Application compatibility (APPLCOMPAT)

New Dashboard for IBM DB2 z/OS

  • The DBA Dashboard is now available both for LUW and for z/OS IBM DB2 connections

  • The following widgets are available:
Widget Description
Simple Select Write a simple SQL query and display its results in a simple widget. Customize its visualization mode and select from several diagram styles.
Quick Notes Use this widget to create simple to-do lists and take quick notes.
Utilities Displays a number of running and stopped DB2 z/OS utilities.
Threads Displays a number of active, inactive, in doubt, postponed, and system threads and related progress bars.
Non-Enforced Constraints

Displays numbers of non-enforced constraints for all schemas in total and for each schema individually. You can easily modify these constraints from the list.

Pending Displays information about which objects have pending definition changes.

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 http://www.toadworld.com/products/toad-for-db2.

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

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

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