Toad^™ for IBM^® DB2^®

Version 3.0.1

Release Notes

September 2007

Contents

Welcome to Toad for DB2

Toad for DB2 is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to DB2 expertise.

Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.

All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.

Back to Top

New in This Release

Review the following:

• For a list of resolved issues in Toad for DB2 3.0.1, refer to Resolved Issues and Enhancements.
• For an overview of updates and new features in Toad for DB2 3.0, refer to Updates in Toad for DB2 3.0 and New Features in Toad for DB2 3.0.

Updates in Toad for DB2 3.0

• General:

  • Tab Renaming—Rename tabs in document windows by pressing F2 or by right-clicking the tab and selecting Rename Document.

• Connections:

  • Connection Organizing—Use drag-and-drop in the Connection Manager to reorganize connections and connection groups.

  • Connection Renaming—Rename connections and connection groups in the Connection Manager by pressing F2 or by right-clicking an item and selecting Rename.

  • Service Management—In the Connection Manager, start, stop, or pause a database service in Windows by right-clicking a connection:
     

    
     

  • Redesigned Connection Toolbar—Perform connection-related actions formerly accessed from the standard Toad toolbar. These actions include Open Connections (used for creating and saving new connections), Commit, and Rollback. The toolbar also contains a drop-down list of available connections, allowing you to switch easily between connections.
     

    
     

    You can right-click the current connection in the drop-down list to access functionality associated with the connection, including options to disconnect from the connection, disconnect from all connections, view connection properties, or open documents associated with the connection.

  • Redesigned Connections Window—Perform these functions and tasks easily from the Connections window (formerly the New Connections window):

    • Click Save to save connection information for later use without having to connect.

    • Edit connection properties in the right pane (including the default DB2 schema or authorization ID and certain DB2 registry settings for the connection), and then save or undo your edits.

    • Create a new connection.

    • Import connections to Toad or export your Toad connections to a file.
       

    
     

• Data Grid:

  • Side-by-Side Grid View—Now display the Card view side-by-side with the Grid view on Data tab.

  • Edit and Read-Only Toggle—Right-click the green (or red) button in the lower left of the Data grid to toggle between edit (Grid has custom editing) mode and read-only (Grid is read-only...) mode.

  • Row Copy Support—Copy multiple cells of data. Press Ctrl and click each cell to select the cells to copy; then right-click and select Copy Rows.
     

    
     

  • Row Flagging—Flag rows on the Data tab in the Database Browser by clicking within the margin of the row. Review the following guidelines for using this feature:

    • This option does not apply to data queried from the Editor.

    • The table you are browsing must have a primary key.

    • The flag is tied to values of the primary key. Therefore, if the value changes, the row is no longer flagged. Also, if you alter the table and change the primary key, all flagged rows are removed.
       

    
     

  • Line Numbers for Data—Add a line number to the margin in the data grid to locate or reference a row quickly when working with colleagues. This feature is enabled in Tools | Options | Environment | Grid.

  • Merge Results—Display results in a single, stacked data grid if a query returns multiple results. This feature is enabled in Tools | Options | Database | Script Result.

• Data Report Designer

  You can now start the Toad Data Report wizard from the Tools menu (select Tools | Data Report Designer) and from within the Reports Manager (right-click a folder and select Create Data Report).

• Database Browser and Object Palette:

  • Primary Key and Not Null Indicators—Easily identify key columns and columns that do not allow null values. A key icon next to a column name indicates a primary key; and an asterisk next to the column name indicates a Not Null column. The Not Null indicator is also available for query result sets in the Editor. (The primary key indicator is not available in the Editor.)
     

    
     

  • Enhanced SQL Generate Feature—Use the Generate SQL option to send a generated SQL script for a table or view to the Editor or a clipboard or to save it to a file:
     

    
     

• Editor:

  • Connection Changing—Change the connection associated with the current window by right-clicking the tab, selecting Change Connection, and selecting an available connection:
     

    
     

  • Tab Renaming—Rename tabs in documents windows by pressing F2 or by right-clicking the tab and selecting Rename Document:
     

    
     

  • Line Commenting—Easily comment or uncomment lines of code by selecting the code text, right-clicking, and selecting Comment Lines or Uncomment Lines. You can also use the keyboard shortcuts Ctrl+Minus (to comment lines) and Ctrl+Shift+Minus (to uncomment lines).
     

    
     

  • Query Execution Enhancements—Display query results using these new enhancements:

    • A collapsed results pane automatically expands when you execute a script (F5) or an SQL statement (F9) or when you verify SQL.

    • Multiple result sets are now merged automatically by default, instead of displaying in separate tabs. A navigation panel displays to the left of the result sets, enabling you to navigate quickly to each set. The number of columns and rows (shown as columns number X rows number) also displays in the navigation panel.
       

      
       

      To specify the default format for displaying results sets (as either merged sets or individual tabs), use Tools | Options | Database | Script Result. You can also modify the maximum number of result sets to display for a query. (The default is 100.)
       

      
       

  • Intellisense—Add an asterisk as the first entry in the auto-completion list for columns. If you specify the asterisk, all columns for the table are added to the list. This feature is enabled in Tools | Options | Editor | Toad Insight.

• ER Diagrammer:
   

  • Add Notes—Right-click a pane, table, or relationship to add notes:
     

    
     

  • Manual Relationships—Create manual relationships.

  • Diagram Schema—Quickly diagram all tables in a schema.

  • Query Builder Integration—Send a diagram to the Query Builder.

• Options Pages:

  • Tree View—Now use a standard tree view to quickly navigate between pages in the Options window.

  • Modeling Options—Go to the Database | Diagramming and Query Builder pages to modify options formerly on the Modeling page.

  • New DB2 Options—On the Database | DB2 page, specify object-editor options for handling advanced alterations, creating object-editor templates, and removing comments in SQL before execution.

  • Updated Keyboard Options—Use the enhanced Environment | Keyboard page to assign keyboard shortcuts more easily:

    • You can now edit the Default keyboard scheme.

    • You can click Default beside the Shortcut currently used by field to revert back to the default shortcuts for the selected keyboard command.

    • You no longer have to click Assign for keyboard shortcuts to be saved. They are now applied when you move the cursor focus to another command.

  • Network Share Option—Specify a location where you can share reports from the Report Manager or files and directories from the Project Manager with your colleagues.

• Project Manager:

  • New Toolbar—Use the toolbar to start the project creation process quickly:
     

    
     

    Use the toolbar to navigate to other projects easily:
     

    
     

  • To-Do Items—Keep up with project or daily tasks using the new To-Do Items feature. To create a To-Do list, right-click a resource node in the Project Manager, and select New | To Do Item:
     

    
     

    Double-click the clipboard beside the To-Do item to assign a due date and to add any notes. With an assigned due date, the item's text changes to red when it is past due. Also, the notes display as a tool tip when you hover the cursor over the item.

• SQL Modeler (now Query Builder):
  • SQL Modeler Renamed—Note that the SQL Modeler has been renamed to Query Builder for this release.
     

    
     

  • Column Enhancements—When adding a column to a query, select the Add All Columns checkbox to add the actual name of each column to the statement. You can also select the Wildcard checkbox to generate SELECT * in the statement.
     

    
     

  • Lookup Table—Quickly map a descriptive column to a column that contains an ID number, so that the description is included in the generated query even if the table that contains the description is not included.

    To access this feature, in the Diagram pane, right-click the ID column for which you want to find descriptive information, and select Find Lookup Table. The Find Lookup Table window is displayed, showing a Tables pane that lists all tables defined with a column with the selected column name.
     

    
     

  • Options Integration—Open the Database - Query Builder options page directly from the Query Builder toolbar.
     

    

New Features in Toad for DB2 3.0

• General:

  • DB2 for LUW Version 9 FixPak 1 Load Modules—Toad for DB2 Version 3.0 ships with the IBM DB2 for LUW Version 9 FixPak 1 modules.

  • Object Notes—Add notes to objects in the Database Browser, Object Palette, ER Diagram, and Query Builder.
     

    
     

• Data Grid:

  • One-Click Export—Easily export data using default settings from the Editor, Query Builder, and Database Browser.
     

    
     

    Note: When using this feature with Database Browser, first select the Data tab before selecting any of the one-click export actions to avoid hanging Toad.

• Database Browser/Object Palette:

  • Object Lists—Group specific objects into named object lists. You can run remedial utilities and object migration in Toad against an object list, without having to select the objects individually. When you run one of these functions against an object list, you can be certain that the generated script does not reference objects that could halt the execution. To run a utility or a migration against an object list, right-click the object list name, and select the option for the appropriate function.
     

    
     

  • Templates—Save and reuse specific object attributes as templates for creating other objects. You can create both regular templates, which you manually load in the object editors, and default templates, which are automatically loaded each time you open object editors. When you define a default template for an object type, Toad gives you the option to designate it as the default for the database (or subsystem) or for the user connection to that database (or subsystem).

    The  toolbar located on each Create or Create Like window provides options to load an existing template or to create a regular or default template from the current object attributes.
     

    
     

  • Advanced Alteration—Perform database object alterations that cannot be performed by ALTER SQL statements. Toad for DB2 analyzes the changes you want to make to objects and generates scripts that contain either ALTER statements or, if advanced alteration is needed, statements that drop and recreate the objects.

  • DB2 for LUW Version 9 Support for Objects—Manage objects using Version 9 enhancements and updates now included in Toad object editors.

  • New Object Editors for DB2 for LUW—Manage DB2 for LUW buffer pools and database partition groups (including stripe sets) using Toad object editors.

  • New Object Editors for DB2 for z/OS—Manage DB2 for z/OS auxiliary tables and storage groups using Toad object editors.

  • Thread Activity (DB2 for z/OS)—View details about current threads connected to your DB2 for z/OS database.
     

    
     

  • Database and Database Manager Configuration Parameter Management (DB2 for LUW)—Review and edit current database and database configuration parameters values.

  • Support for Transfer Ownership (DB2 for LUW)—Change ownership of objects using the DB2 TRANSFER OWNERSHIP command.
     

    
     

  • Enhanced Table and Index Reorganization Utility (DB2 for LUW)—Run this utility on one or more tables or indexes at the table, index, or tablespace level. The newly designed Reorg window lets you specify reorganization options for the individual tables or indexes and for the REORG command in general. Additionally, the utility now supports both REORG INDEXES ALL and REORG INDEX commands.
     

    
     

  • New RUNSTATS Utility (DB2 for LUW)—Execute this utility on one or more tables at the table or tablespace level. The Runstats-Tables window allows you to specify RUNSTATS options for individual tables and for the command in general.
     

    
     

• Debugger:
  • Debug Support for DB2 for z/OS SQL Stored Procedures—Now compile and debug stored SQL procedures in DB2 for z/OS. Refer to the Toad for DB2 Getting Started Guide for a description of the system requirements for running the compile and debug components.
• Diff Viewer:

  Compare differences in DDL or in files using the new Diff Viewer. Access the Diff Viewer using one of the following methods:

  • Select Tools | Diff Viewer. You can then select any two files to compare.

  • Right-click an object or data grid, and select Send To | Diff Viewer.

  Note: You cannot make updates to files in the current database.

• Editor:
  • DB2 for LUW CLP Command Execution—Execute DB2 for LUW CLP commands using the Editor.

• Microsoft Excel Integration

  You can now open existing reports or spreadsheets without leaving Toad.

  Note: When using this feature, have only one Excel file open at a time. If more than one file is open, the Excel toolbar is disabled for the additional files.
   

  
   

• Object Migration (LUW and z/OS)

  The Toad for DB2 Schema Migration wizard migrates objects from a source DB2 database or subsystem to a target database or subsystem. The migration process runs in the background so you can continue to work on other tasks. To start the wizard, select one or more objects to migrate, right-click, and select Migrate Object(s). You can also select Advanced | Migration.

  Using Schema Migration wizard, you can do the following:

  • Use a powerful filter-building tool to select the objects to migrate.
     

    
     

  • Select to migrate objects from several schemas at once.
     

    

  • Select to migrate DDL or statistics or both for a given object.
     

    
     

    Note: Currently Schema Migration does not migrate object data.

  • Resolve potential conflicts by defining transformation rules that change schema and other attributes on the target objects.
     

    
     

  • Customize the migration execution. For example, you can choose to run the migration script immediately or within a Toad Editor session, save the migration script to a file, save the current Schema Migration project to a file, have the wizard run in the background during the migration, or have a report generated when the migration completes.
     

    
     

• Quest IBM DB2 for z/OS Component

  The new Quest IBM DB2 z/OS component is available with this release of Toad for DB2. You install this component on each DB2 for z/OS subsystem that you want Toad to manage. In addition to the object-management functionality already provided with Toad, this component enables you to perform the following in Toad:

  • View the list of volumes available for defining a storage group in the subsystem.

  • View the information about the current threads connected to the subsystem.

  • Perform future product features

  For complete information about installing this component, refer to the Quest IBM DB2 z/OS Component Installation Guide, available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.
• Reports Manager

  The new Reports Manager lets you quickly manage reports or use canned reports provided by Toad. To access this feature, select View | Reports Manager.

  
  
   

• Special Register Feature

  Toad now supports editing DB2 special register values at the connection level and at the Editor level.

  When you set up a Toad connection to a DB2 database or subsystem, you can define certain special register values that are then in effect each time Toad connects to the database or subsystem.
   

  
   

  Additionally, you can override special register values for the duration of a specific Editor session. To do so, click the Set Register Value toolbar button in the Editor to display the Alter Special Registers window. Then make changes to the listed special register values.
   

  
   

  To be able to override special register values in the Editor, make sure that you use the following settings on the Tools | Options | Editor | General page:

  • The Use specific connection for each open editor checkbox is selected.
  • The Allow changing executing connection in editor checkbox is cleared.
• Troubleshooting
  • SQL Trace Support—Log information for all executed SQL to a file or to the Output window by enabling SQL Trace.
     

    
     

    If you select to log information to a file, this log file is stored in C:\Documents and Settings\username\Local Settings\Application Data\Quest Software\Toad for database version\ConnectionTrace.log. You can view the log file in the Editor by selecting Tools | SQL Trace | Show Logfile.

    Note: Because SQL Trace logs information for each execution, it can slow performance on your computer.

  • Troubleshooting Help—Use Troubleshooting topics in the online help to resolve connection and debugging problems and other issues.

• Version Control:
  • Robust Integration with VCS Vendors—Take advantage of Toad's more in-depth integration with popular VCS vendors. Currently, Toad has integrated version control with Visual Source Safe.
  • Object and SQL Script Support—In addition to files, archive revisions to database objects and SQL scripts from the Database Browser.
  • Version Control Setup Wizard—Run a user-friendly wizard to configure version control to work with Toad.
• Web Search

  Use the new Web Search feature to Google (or perform another type of web search) without leaving Toad. From the toolbar in the main window, select the search engine type (such as Google), enter the search criteria, and click Search.
   

  
   

  Customize you searches by adding your own search engines or web sites under Tools | Options | Environment | Quick Search.
   

  
   

Back to Top

Resolved Issues and Enhancements

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

Resolved Issues and Enhancements in 3.0.1

Resolved Issues and Enhancements in 3.0

Back to Top

Known Issues

The following is a list of issues known to exist at the time of the Toad for DB2 release.

Back to Top

Third Party Known Issues

The following is a list of third party issues known to exist at the time of the Toad for DB2 release.

Back to Top

Upgrade and Compatibility

Please review upgrade information in the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.

Back to Top

System Requirements

Verify that your system meets the following minimum requirements.

Client Requirements

Toad for DB2 client installation requires the following.

Note: If a DB2 for LUW 7 client is installed on the machine where you are installing Toad, you must upgrade the DB2 client to version 8 before installing to avoid losing functionality is some DB2 native tools.

Server Requirements

Each DB2 database server requires the following:

User Privilege Requirements

The following user privileges are required for installing and running Toad:

• Only Power users and Administrators can install Toad.

Note: Power users cannot install Toad on a Windows Vista Enterprise machine. This Windows limitation is due to the fact that the Power User mode is no longer used in Vista and therefore cannot install applications.

• A 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.
• If a Power user installs Toad, a Restricted user can run the application but cannot do the following:

  • Associate file extensions.

  • See the Toad for DB2 icon on the desktop or the Toad for DB2 menu options in the Windows Start menu. As a workaround, Restricted users can create a shortcut to the application from the install directory and place the shortcut on their desktop.

• If an Administrator installs Toad, the Administrator can share the Toad for DB2 desktop icon and menu items with any user on the computer.
• Network and LAN installations are currently not supported.
• In order to use Toad with DB2 for z/OS, any user who does not have SYSADM privileges must be granted SELECT permissions on the DB2 catalog tables.
• In order to run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

  1. From the Windows Start menu, select Settings | Control Panel.

  2. Double-click Administrative Tools.

  3. Double-click Microsoft .NET Framework 2.0 Configuration.

  4. Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.

  5. Click Evaluate Assembly from the lists of tasks in the right panel. An Evaluate an Assemble window displays.

  6. Browse to the location of Toad.exe in the File field.

  7. Click Next to view permissions for Toad.exe.

  8. Set the permission to Unrestricted.

• In order to set or modify Toad Security settings, users must have privileges to create the QuestSoftware.ToadSecurity table if it does not already exist. If the table does exist, users must have privileges to insert, update, and delete data in the table.
• Power users and Restricted users do 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 to import catalog entries to Toad.
• To load log files on the Toad client machine for a Log Reader session, the user must have the following privileges:

• READ permissions on the log files belonging to the database and on the directory where these files are stored

• Database administrator privileges to read the database's log.

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server Service Pack 2 using the Metaframe Access Suite 3.0 and Citrix Presentation Server Clients 10.0. For information about installing Toad in a Citrix environment, refer to Install Toad on a Citrix Machine in the Toad for DB2 Getting Started Guide.

LDAP Requirements

To connect to a Lightweight Directory Application Protocol (LDAP) server, you must enable LDAP support and specify the host name and port number of the LDAP server for the DB2 client installed with Toad.

Note: You must configure LDAP support for the DB2 client installed with Toad regardless of whether an existing DB2 client on the machine is already configured to support LDAP.

To configure Toad to use LDAP

1. Open the Command Window for the DB2 client installed with Toad by selecting Start | All Programs | IBM DB2 | <ToadCom, ToadEval, or ToadFree> | Command Line Tools | Command Window.
2. Type the following command to enable LDAP support:

db2set DB2_ENABLE_LDAP=YES

3. Type the following command to specify the TCP/IP host name and port number of the LDAP server:

db2set DB2LDAPHOST=hostname[:port]

The port number defaults to 389 (default LDAP port) if you leave the port number blank.

4. Exit the Command Window.
5. Launch Toad and open the New Connection window.

Databases on the LDAP server should be available from the Database Alias drop-down list.

Note: At this point, Toad for DB2 supports only the access of DB2 LDAP catalog entries. Toad does not support the management of these entries (such as adding or removing them) Debugger Requirements

Compile and Debug Requirements for Stored SQL Procedures

The following are the requirements for using Toad to compile and debug stored SQL procedures in DB2 for z/OS.

Toad Client Requirements

To use the Toad debugger on stored SQL procedures, the following Toad client requirement must be met:

• The Toad client is running on a Windows XP machine.
• Java Runtime 1.4 or later is installed and specified in your system path.

DB2 Subsystem Requirements

Each DB2 subsystem on which you want to compile and debug stored SQL procedures must meet these requirements:

• To compile stored SQL procedures in Toad, the DB2 stored procedure SYSPROC.DSNTPSMP must be operational on the subsystem.
• To debug stored SQL procedures in Toad, the IBM DB2 installation job DSNTIJSD must be executed on the subsystem.

Back to Top

Global Operations

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. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Far-East Asia, Japan.

This release has the following known capabilities or limitations:

• Toad Editions that contain Knowledge Xpert.

The Knowledge Xpert feature is available with English language content only.

Back to Top

Getting Started

Contents of the Release Package

The Toad for DB2 release package contains the following products:

1. Toad for DB2 3.0
2. Quest IBM DB2 z/OS component
3. Product Documentation, including:
   • Getting Started Guide
   • Online Help

Installation Instructions

For important information about installing Toad for DB2, refer to the Toad for DB2 Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.

For instructions on installing the Quest IBM DB2 z/OS component, refer to the Quest IBM DB2 z/OS Component Installation Guide. This guide is available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.

Back to Top

For More Information

Contacting Quest Software:

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

Contacting Quest Support:

(Commercial and Trial Support only)

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com/.

From SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents).
• Download patches and upgrades.
• Seek help from a Support engineer.
• Log and update your case, and check its status.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.

Yahoo Group

(Freeware Support)

You can