Toad™ for IBM® DB2® 6.3
Toad® for IBM® DB2® 6.3
(Click here for previous versions)
Friday, August 4, 2017
About Toad® for IBM® DB2®
Resolved Issues and Enhancements
Third Party Known Issues
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.
In Toad® for IBM® DB2® 6.3 the following new features were implemented:
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
- 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
LUW Specific Features
- 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
Support for New DBM and DB Configuration Parameters
|Database configuration parameters
|Database manager configuration parameters
- Batch Analysis can now be easily launched as a part of Toad Automation
- 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:
||Write a simple SQL query and display its results in a simple widget. Customize its visualization mode and select from several diagram styles. |
||Use this widget to create simple to-do lists and take quick notes.|
||Displays a number of running and stopped DB2 z/OS utilities.|
||Displays a number of active, inactive, in doubt, postponed, and system threads and related progress bars.|
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.
||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®.
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.
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
2 GHz processor (recommended minimum)
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.
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)
Microsoft® .NET Framework 4.5.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® 7.0 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 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|
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 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.)