Toad™ for IBM® DB2® 6.5

Toad® for IBM® DB2® 6.5

Release Notes

Tuesday, November 14, 2017

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

General Features

Object Details

Object Overview Tab

• Display information from several Object Details tabs at once
• The new object Overview tab allows you to display any other tab at once
• Add, remove and replace panes and add formatting aids such as labels and separators to further organize your Overview

• Click Customize Layout to edit layout and add or remove data from more Object Details tabs

Grants Tab

• A new Grants tab that displays any CREATE ROLE and GRANT ROLE statements for a selected role
• Double-click a role in Object Explorer and select Grants

Compare Object

• Check Format object body before comparing in step 2 of Compare Object to make it easier to spot any differences

Dashboard

• Now you can scroll your Live Query widget to left and right to display more columns as needed

• Both LUW and z/OS dashboards can now be shared between connections
• Click Dashboard | My Dashboards and select Clone to share a dashboard

LUW Specific Features

User Privileges

• Cataloged global temporary tables are now displayed in User Privileges Editor
• Right-click a user in Object Explorer and select Alter User
• Select CGT Table to edit privileges for cataloged global temporary tables

LUW Utilities

• INPLACE clause is supported for LUW REORG

Space Management

• A new Object Detail tab is available, which lists unused indexes and their last used date
• Right-click an index in Object Explorer and select Space Management | Identify Exceptions

• When working with Batch Analysis within Automation a new checkbox is available
• Check Unused Index Report to generate report about unused indexes in your database

ADMIN_MOVE_TABLE

• Right-click a partitioned table in Object Explorer and select Space Management | Analyze Table Partitions
• A new option ADMIN_MOVE_TABLE is available for Data Preservation Options

z/OS Specific Features

Partitioned Data Set Support

• Now you can send any scripts to your Partitioned Data Set members or load any scripts from your PDS members into SQL Editor
• Click Save SQL script to a PDS member or Open SQL script from a PDS member in any SQL Editor.

z/OS Utilities

• A new Object Details editor is available for z/OS Report utility
• Right-click a tablespace or an index in Object Explorer and select Utilities | Report

• New Object Details editors are available for z/OS Modify Recovery and Modify Statistics utilities
• Right-click a tablespace in Object Explorer and select Utilities | Modify Recovery/Statistics

Compare Object

• New Advanced Option is available, check Generate DEFER for indexes to generate DEFER YES clause for indexes

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:

Server Requirements

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

Virtualization Support

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

Resolved Issues and Enhancements

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