Toad™ for IBM® DB2® 6.1

(Click here for previous versions)

Release Notes

Thursday, June 25, 2015


Welcome to Toad for IBM DB2

New in This Release


LUW Specific Features

z/OS Specific Features

Resolved Issues and Enhancements

Deprecated Features

Known Issues

Third Party Known Issues

System Requirements

Global Operations


Getting Started

For More Information

Welcome to 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 in This Release

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

General Features

New Database Map Feature

Database Map displays selected DB2 objects in a well-arranged customizable environment that clearly shows the architecture of the database. The arrows connecting objects reflect the reference relation. The arrows point to the referenced objects. Each object icon shows its icon, name and type.

The central object is indicated by bold text and is used as a pivot point to the map. Drag and drop an object to the map or left-click and hold it to make it central.

The current object is the object under mouse pointer.

The selected object is an object indicated by check icon in its corner. Hold Ctrl and Left-click to select one or more objects.

Using mouse to work with the Database Map

Using the GUI to work with the Database Map

Compare Object Enhancements

Automation Enhancements

Throw Error Activity

Automation Reports and Container Activities

Query Builder Enhancements

Background Processes

Analyze Joins

Sort Columns

View PDF Files in LOB Viewer

New Impacted Objects Tab for Table Editor

New TimeStamps

Support for JAR Objects

UI Enhancements

Case Sensitivity Option for Database Explorer

Automatic Aliasing for Code Completion

LUW Specific Features

Compare Object Enhancements

Support for 10.5 Cancun Features

Shadow Tables (IBM DB2 10.5)

String Unit Attributes

Diagnostic Log Reader

z/OS Specific Features

z/OS Utilities

Support for z/OS QMF Queries

Support for ALTER of Multiple Objects

Object Attributes




Dataset/Partition size (DSSIZE)

Maximum rows per page (MAXROWS)

Segment size (SEGSIZE)

Maximum partitiions (MAXPARTITIONS)

Lock size

Maximum locks (LOCKMAX)

Log changes (LOGGED)

Dataset elligible for close (CLOSE)


Data capture

Restrict on drop




(Drop) Versioning

(Disable) Archiving







Datasets elligible to close (CLOSE)


Piece size unit

Piece size value

Display Runstats profile values

Enhanced Script Generation

Display Administrative Authorities

Display ZPARMs values for z/OS Subsystems


Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Feature Resolved Issue Defect ID
Automation Job Manager button is now displayed correctly. TDB-1725/2770019-1
Compare Object It is now possible to see the original un-mapped DDL source in Compare Object report. TDB-1352
z/OS indexes are now compared correctly. TDB-1555/2695249-1
Script is now generated correctly for tables with DATA_CAPTURE_CHANGES. TDB-1739/2747072-1
Connection Manager Version 8 DB2 client does not throw exception anymore. TDB-1388/2625216-1
Configuration Wizard LOCAL databases are now supported by Client Config Wizard and Database Wizard. TDB-1579/2721595-1
Data Generator Use dictionary option has been removed. TDB-1524
Data Grid Data Grid sorting works correctly. TDB-1447/2666505-1
ER Diagrammer Database Diagram correctly shows relationships to older tables. TDB-1595/2693558-1
Export Wizard Export Wizard now works with WITH statement. TDB-1372/2633713-1
General DB\DBM Parameters Compare does not include user IDs and passwords. TDB-1424
It is now possible to connect to DB2 databases where DB2_IMPLICIT_UNICODE=YES. TDB-1706/2759114-1
COMMIT ON RETURN YES is not lost on Stored Procedures anymore. TDB-1321/2619735-1
Object Details (DOV) Variable dependencies to Cursor types are now displayed. TDB-1331
  • New Tab for Object Details displaying Administrative Authorities for Subsystem.
  • TDB-1656
    Display of related Packages and Plans has been enhanced. TDB-1655
    Object Explorer Numbers in extra columns are now aligned correctly. TDB-1448
    Object filter now works correctly for indexes with TABSCHEMA, TABNAME, Create Time or Stats Time defined. TDB-1381/2628493-1
    QMF Queries are now supported. TDB-1314
    Filtering now supports ignore case option. TDB-1284
    ĻUW Compression analysis does not fail for large tables. TDB-1558/2701272-1
    Object Editor (DOE) ALTER, REBIND, and BIND LIKE now work for COBOL packages. TDB-1578/2680214-1
    Altering compression values of multiple objects works correctly. TDB-1418
    Multi Object Alters are now supported for some z/OS objects. TDB-1325
    z/OS Extended Alter on Table with Clone table now generates script correctly. TDB-1436
    Options It is not possible to set background to transparent. TDB-1532/2706746-1
    Profiling/ETL Exception when a date 9999-12-31 was used does not occur anymore. TDB-16862755970-1
    Script Generation Toad for DB2 LUW REBIND package does not generate REVOKE statements anymore. TDB-1526/2696715-1
    Indexes with no tablespaces do not throw exception anymore. TDB-1713/SR 2696713-1
    Grant statements are now generated for z/OS stored procedures. TDB-1460
    Space Management Space Usage History Viewer now shows correct values for pureScale databases. TDB-1598/TDB-727/2723148-1/2452817-1
    Space Calculator now shows correct values. TDB-1597/2723148-1
    SQL Editor Close All Result Sets option now works correctly. TDB-1657
    Bind Variables now work correctly. TDB-1564
    Highlighting for Explain plan now works correctly. TDB-1716/2762985-1
    z/OS Utilities SYSIBM indexes and indexes with trailing spaces in CREATOR column are now supported by Rebuild index. TDB-1565/2692591-1
    RUNSTATS Utility statement is now generated for all Tablespaces selected. TDB-1501/2693827-1
    RUNSTATS Utility statement generates statement without 'SAMPLE' correctly. TDB-1560/2701682-1
    z/OS Commands START DATABASE SPACENAM script is now formatted correctly. TDB-1467

    Known Issues

    Currently known issues in Toad for IBM DB2 6.1:

    Feature Description Support Case/Defect ID
    Object Details When a DB2 object is created, DB2 implicitly creates authority for the user who created that object. In the system catalog tables those are shown as SYSIBM as the Grantor. When migration\compare\extended alter scripts are generated Toad does not generate GRANT statements in those scripts for authorizations granted by SYSIBM because those are granted implicit authorizations that have been created by DB2. TDB-870

    You might encounter issues with initializing Unified Debugger sessions if the version of the DB2 for LUW server on which you are debugging is earlier than 10.1 fix pack 2.

    Workaround: If the DB2 server version is earlier than DB2 for LUW 10.1 fix pack 2, copy DB2DBGM.JAR from the Toad client installation to the following location on the server:

    • DB2 instance home path/SQLLIB/JAR (Unix or AIX computer)
    • DB2 instance home path\SQLLIB\JAR (Windows computer)


    If the DB2 server version is DB2 for 10.1 fix pack 2, use the JAR file supplied with your DB2 version. If replacing the JAR file as described in the workaround, make sure you back up the original JAR file on the server before replacing it with the one from the Toad client installation.

    You may encounter problems setting breakpoints and variable watches when using the Unified Debugger on LUW instances 10.1 fixpack 2 and higher. ST110352
    Currently, the debugger does not support Unicode schema names. ST41770

    After a STEP OUT request, the Debugger momentarily returns to the line just after the call to the inner procedure and then proceeds to execute to the end of the calling procedure.

    Workaround: Set a breakpoint after the call to the inner procedure.

    Export Wizard/ One Click Export Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit. N/A
    Extract DDL

    Extract DDL(z/OS) When extracting DDL for Database with "Include objects that are dependent upon those originally selected" the indirectly dependent objects (e.g. tables, indexes, etc.) are not included in the script if the tablespace was excluded.

    Workaround: Instead of selecting the Database and invoking Extract DDL, select the Tables and invoke Extract DDL Or Select the Database and invoke the Migrate Object feature. Then select “Include Objects that are dependent’ and ‘Process multiple object levels’. Then you can selectively include or exclude the DDL for specific objects.


    Attempting to launch Toad results in a System.Security.Policy.PolicyException error.

    Workaround: Ensure that the system administrator has placed Toad in the correct code group with permissions to execute code.

    Customized options defined in Toad's Configuration wizard are not applied if you are running as a Restricted user. CR216699

    Toad z/OS Components reference QUEST.QC200ZPARM function, which leads to the S378 Abend, when running IBM DB2 z/10 subsystem in Conversion mode with older versions of Toad.

    Workaround: DROP QUEST.QC200ZPARM function from your DB2 z/OS 10 subsystem. This will eliminate the possibility of the function being called into the WLM environment procedure and causing the S378 abend. We do not recommend you to just STOP QUEST.QC200ZPARM function on the mainframe side, without actually dropping it, because that may cause Toad or batch process (QCEXEC – remote job execution) hang. Dropping QUEST.QC200ZPARM function is recommended.

    Installation The Toad installation process installs a DB2 client in the specified Toad installation path. If the user chooses to override the default Toad installation path, the new path cannot include Unicode characters because the DB2 client installation does not support such characters. N/A
    Network and LAN installations are currently not supported. N/A

    When installing Toad using Quest Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message.

    Workaround: Select This program installed correctly to continue installation.

    For more information, see here.


    Toad uses hardcoded values instead of some variables such as %USERNAME% in several path names and therefore App-V environment is not supported.

    For installation adhere to Windows Installer Best Practices, see here.

    Pivot Grid TIMESTAMP is not detected as date column in pivot grid. ST90996
    Space Management

    If running Toad for IBM DB2 6.0 or earlier in a pureScale environment and the QUEST.SH_SNAPSHOT procedure had been installed, the procedure will have to be redefined. Please, follow these steps:

    1. Drop procedure QUEST.SH_SNAPSHOT
    2. Right click a tablespace
    3. Select Space Management | View Space History
    4. Click Yes when prompted to run the install script for the procedure
    5. Execute the script
    SQL Editor

    When using Korean symbols in comments (beginning with "--") for SQL script, the comment line and any following lines in the statement are treated as comments.


    Korean symbols should not be used in comments beginning with "--"


    Block style comments should be specified like "/* comment */"

    Toad does not handle DBMS_OUTPUT in the SQL Editor. ST90710
    z/OS Utilities

    When using Utilities as the data preservation method and the length of a column tied to columns from other tables via RI is reduced. When executing the alter script the load fails with a DSNU334I INPUT FIELD INVALID error pointing to the altered column. The load cards show the old length for the altered column which appears to be the problem.



    Third Party Known Issues

    Feature Description Support Case/Defect ID
    DB2 Client

    In case Toad and a 9.5, 9.7 or 10.1 DB2 client is installed on Windows 8 or Windows Server 2012 IBM setup recommendation #1618434 has to be applied.

    LUW Procedure Script Tab

    After installing DB2 LUW v10.1.3, the script tab for LUW procedures is empty. This is due to an issue introduced by IBM in fixpack 3 regarding the NULLIF SQL function.

    IBM APAR IC96725 addresses this issue.

    DB2 z/OS invalid Timestamp values returned

    When the IBM DB2 Analytics Accelerator is used in conjunction with DB2 z/OS, along with an IBM DB2 .Net Data Provider v10.1.3, timestamp values returned from queries are invalid. Since Toad DB2 v5.6 uses the IBM DB2 v10.1.3 .Net Data provider, invalid timestamp values can be returned within Toad 5.6. IBM PMR 8862756 has been opened on this topic.

    Please consult that PMR for a work-around.

    LUW Procedure Debugging

    When the user is running DB2 Server 10.1.3 with a database that has been migrated from a previous release, the debugger will fail with a reference to SYSDEBUGPRIVATE. This occurs from an IBM bug in the db2updv10 update utility.

    IBM APAR IC96837 addresses this issue. This has been resolved in IBM DB2 10.1 FixPack 4.


    The Debugger may not advance to the next line under certain circumstances. Those circumstances include DECLARE statements with multiple variables defined on a single line and IF statements with multiple conditions defined on a single line.


    In procedures that are to be debugged: The procedure text should be modified to separate DECLARE variables onto different lines and IF statements separated to have conditions on separate lines.


    LUW: The following error message is displayed when you attempt to modify a watch value during a Debug session on a DB2 for LUW 9 database: "ERROR [57011] [IBM][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011" The call to modify the watch value fails on DB2, and the server runs out of heap memory.

    Workaround: To avoid the heap memory issue, increase the application heap size on the server.

    General A double-byte character cannot be inserted into a database with a single-byte codepage. IBM PMR30857,756,000 states that this configuration is not supported. CR220327

    If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance.

    To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at Microsoft Support.

    Export Wizard/ One Click Export

    To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:


    Date formatting issues occur when exporting table data to an Excel file or instance. These issues seem to occur especially when exporting dates previous to 1900.

    Workaround: For better results, try exporting the data to a CSV file.

    Object Editor (DOE)

    z/OS: Executing a procedure causes "Invalid SQL syntax" message when parameter listing has a new line character separating parameters. IBM has opened PMR 80539,756 to investigate this issue.

    Workaround: Remove the new line character and separate the parameters by the spaces.

    z/OS Utilities

    DB2 LOAD utility with IGNOREREFIELDS YES does not work with DEFLOAT(34) field, gets error message: DSNU3381 DSNURUFL - INVALID COLUMN SPECIFICATION FOR TEST_CREATE_DEFLOAT1

    Refer to IBM PM53520 for more information.


    LOAD statement fails on partitioned table with 138 columns and leads to loss of data.

    Refer to IBM PMR 00276,756 for more information.


    System Requirements

    Client requirements

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


    1 GHz minimum


    512 MB of RAM minimum, 1 GB recommended

    Note: The memory required may vary based on the following:

    • Applications that are running on your system when using Toad for IBM DB2
    • Size and complexity of the database
    • Amount of database activity
    • Number of concurrent users accessing the database

    Hard Disk Space

    212 MB to run Toad for IBM DB2

    Allocate additional space for the following components as needed (provided with Xpert Editions):

    • If installing Dell™ SQL Optimizer for IBM® DB2® z/OS or Dell™ SQL Optimizer for IBM® DB2® LUW, see the SQL Optimizer Release Notes for disk space requirements.

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

    Windows® 7 Service Pack 1 (32-bit or 64-bit)

    Windows® 8 (32-bit and 64-bit)

    .NET Framework

    .NET 4.5

    Database Client

    DB2® Client

    Toad requires that a DB2 Client version 9.7.6 through 10.5 be installed as default.

    Toad for IBM DB2 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, and 10.5.3.

    Additional Requirements

    Web Browser

    Microsoft® Internet Explorer® 8.0 or later

    Server Requirements

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

    Database Server

    IBM DB2 for LUW 9.1, 9.5, 9.7, 10.1, 10.5,

    IBM DB2 for z/OS 9, 10, 11

    Note: Toad may support IBM DB2 Express and SWE in addition to listed above servers, but note that no testing was performed on it.

    Virtualization Support

    Review the following information about using Toad for IBM DB2 in virtual environments:

    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 for IBM DB2:

    Only Windows Administrators and Power Users can install Toad.

    Note: The following exceptions exist for Power Users:

    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:

    User requirements to run Toad for IBM DB2

    The following describes the requirements and restrictions for users who launch and run Toad:

    Requirements for Full Access to Toad for IBM DB2 for DB2 z/OS Functionality

    You must install the Toad for IBM DB2 z/OS components on each IBM DB2 for z/OS subsystem that you want to manage using Toad for IBM DB2. The z/OS components enables you to use Toad to perform the following functions on the IBM DB2 subsystem:

    Recommended Indexes to Improve Toad Performance in DB2 for z/OS

    User-defined indexes on specific system catalog tables can improve performance when you are browsing DB2 for z/OS objects in Toad. The following link contains the DDL for indexes that can optimize Toad performance on your DB2 for z/OS subsystem. Keep in mind that the creation of these indexes is a recommendation only. The indexes can have different results in different environments, depending on the number of DB2 objects and the amount of data involved.

    To create these indexes, edit and run the following DDL:

    Recommended Indexes

    Additionally, if the schema drop-down lists in the Object Migration wizard populate slowly, consider creating an index on the SCHEMA and CREATOR columns in the catalog table for each object type. Here is a list of some of the object-type tables:

    Global Operation Statement – Toad for IBM DB2 6.1

    This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

    This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

    This release has the following known capabilities or limitations: ** During the Toad for IBM DB2 installation process, if the user overrides the default installation path, the new path specification cannot contain Unicode characters. This limitation exists because Toad installs an IBM DB2 for LUW client in the specified Toad installation path, and IBM DB2 installations do not support Unicode characters.

    ** (This limitation applies ONLY to the Xpert edition of Toad for IBM DB2 for z/OS and to the DBA edition of Toad for IBM DB2 for LUW) Dell SQL Optimizer for IBM DB2 z/OS and Toad Remote Script Execution (for IBM DB2 LUW or z/OS) support single-byte character sets only. These features do not support double-byte or multi-byte character sets. All IBM DB2 client and server installations should be configured to use the same or compatible character encodings and the same locale and regional options.


    Getting Started

    Contents of the Release Package

    The Toad release package contains the following products:

    1. Toad™ for IBM® DB2® 6.1
    2. Toad for IBM DB2 z/OS Components

    3. Product Documentation, including:


    To enter your license key

    1. Select Help | Licensing from the menu (ALT+H+L).

    2. Review the following for additional information:

      Authorization key

      Enter the license key for Toad for IBM DB2.

      Site message

      Enter the site message included with the license key.

      Note: Your license key determines the edition of Toad for IBM DB2 (Freeware, Base, Xpert, etc.) and will enable the functionality accordingly. In many cases, if functionality is disabled within Toad for IBM DB2, you may not have an appropriate license to use it. When Toad is running, you can see which components are licensed by selecting Help | About. For complete list of features shipped with your Toad edition see

      Note: The license is provided for all products and Toad components purchased within Toad for IBM DB2 Edition.

    For More Information

    Get the latest product information, find helpful resources, test the product betas, and join a discussion with the Toad for IBM DB2 team and other community members.

    Contact Information

    Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visit


    Technical Support:
    Online Support

    Product Questions and Sales:
    (800) 306 - 9329


    About Support

    Support is available to customers who have a trial version or who have purchased Dell software and have a valid maintenance contract. The Support Portal at is the definitive resource for technical support with self-help capabilities so you can solve problems quickly and independently 24 hours a day, 365 days a year. The portal also provides direct access to our support engineers through an online service request facility. From one central location, you will find everything you need – support offerings, policies and procedures, contact information, as well as:

    1 For trial users please use the Trial Downloads to get the latest generally available version of the software.


    © 2015 Dell Inc.


    This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Dell Inc.

    The information in this document is provided in connection with Dell Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Dell Software products. EXCEPT AS SET FORTH IN DELL SOFTWARE’S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL DELL BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF DELL SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Dell does not make any commitment to update the information contained in this document.

    If you have any questions regarding your potential use of this material, contact:

    Dell Inc.
    Attn: LEGAL Dept
    5 Polaris Way
    Aliso Viejo, CA 92656

    Refer to our Web site ( for regional and international office information.


    Dell, the Dell logo, Quest, Benchmark Factory, Spotlight, SQL Navigator, vWorkspace, and Toad are trademarks of Dell Inc. and/or its affiliates. Microsoft, Windows, Active Directory and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates. UNIX is a trademark or registered trademark of The Open Group in the United States and other countries. SAP® and SYBASE® are the trademark or registered trademark of SAP AG in Germany and in several other countries. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims any proprietary interest in the marks and names of others.