Toad World

Toad for DB2 Version Comparison Tool

Customers frequently ask us “what’s new in Toad?”  We used to point them to the release notes but that was only useful if you were one release behind and then you still had to figure out which features applied to the bundle you’re using.  The Toad for DB2 Comparison Tool does all that work for you.  

To get started, select the version and bundle of Toad for DB2 you’re running.  We’ll show you all the great new features you’ll get when you upgrade to the latest version!

This tool is current through v6.2 (generally available on April 14, 2016).

Current version is:
What version are you using?
Version number:
Bundle:

What you gain when you upgrade from to

(added in version )
6.2 added these features (Click "+" to view) Business Value
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
6.1 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
6.0 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Clicking on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Compare & Synch New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. 
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
5.6 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.1
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 z/OS Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 z/OS Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Clicking on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for DB2 z/OS Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. 
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
5.5 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hoverig on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hoverig on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hoverig on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Clicking on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
5.3 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Clicking on a tab for a z/OS connection will now also show the data sharing member name.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Toad Development Suite for DB2 (Click "+" to view) Business Value
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Clicking on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Spotlight on IBM DB2 LUW Support for IBM® DB2® LUW 10.5 - Spotlight™ on IBM® DB2® LUW now supports IBM® DB2® LUW 10.5. Citrix XenApp v6.5 - Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
5.2 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Spotlight on IBM DB2 LUW Support for IBM® DB2® LUW 10.5 - Spotlight™ on IBM® DB2® LUW now supports IBM® DB2® LUW 10.5. Citrix XenApp v6.5 - Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
5.1 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
CONNECT by using Directives Now you can use directive CONNECT ALIAS that will allow you to execute your queries from one Editor on different servers.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Performance Improvements Most queries for the script generation were tuned, so scripts are now generated faster.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
Version Control Enhancements Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems: Subversion 1.5.6 or later, Team Foundation Server 2005, 2008, 2010, and File System Based provider
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
CONNECT by using Directives Now you can use directive CONNECT ALIAS that will allow you to execute your queries from one Editor on different servers.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Performance Improvements Most queries for the script generation were tuned, so scripts are now generated faster.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL PL Debugger Toad can Debug your PL/SQL Stored procedures.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
Version Control Enhancements Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems: Subversion 1.5.6 or later, Team Foundation Server 2005, 2008, 2010, and File System Based provider
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
CONNECT by using Directives Now you can use directive CONNECT ALIAS that will allow you to execute your queries from one Editor on different servers.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Performance Improvements Most queries for the script generation were tuned, so scripts are now generated faster.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL PL Debugger Toad can Debug your PL/SQL Stored procedures.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
Version Control Enhancements Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems: Subversion 1.5.6 or later, Team Foundation Server 2005, 2008, 2010, and File System Based provider
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
DB2 z/OS Dynamic Statement Cache The statements in the Dynamic Statement Cache (DSC) can now be viewed in Toad. IBM DB2 uses the DSC as a memory pool area to store SQL statements (SELECT, MERGE, UPDATE, INSERT, DELETE) that may be executed multiple times across different packages, plans and threads in Toad. Storing reusable statements in the DSC helps to improve performance as SQL preparation processes are reduced.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
CONNECT by using Directives Now you can use directive CONNECT ALIAS that will allow you to execute your queries from one Editor on different servers.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Performance Improvements Most queries for the script generation were tuned, so scripts are now generated faster.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL PL Debugger Toad can Debug your PL/SQL Stored procedures.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
Version Control Enhancements Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems: Subversion 1.5.6 or later, Team Foundation Server 2005, 2008, 2010, and File System Based provider
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
CONNECT by using Directives Now you can use directive CONNECT ALIAS that will allow you to execute your queries from one Editor on different servers.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Performance Improvements Most queries for the script generation were tuned, so scripts are now generated faster.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL PL Debugger Toad can Debug your PL/SQL Stored procedures.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
Version Control Enhancements Version Control has been completely redesigned to become easy-to-use, secure and reliable. Version control can be configured in Toad to work with the following version control systems: Subversion 1.5.6 or later, Team Foundation Server 2005, 2008, 2010, and File System Based provider
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
SQL Optimizer for IBM DB2 LUW Supports IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. Support for recommending Indexes for a single SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible.   Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012.   
SQL Optimizer Integration A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
Benchmark Factory Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include.
Toad Data Modeler Support for DB2 10.5 (LUW)
Spotlight on IBM DB2 LUW Support for IBM® DB2® LUW 10.5 - Spotlight™ on IBM® DB2® LUW now supports IBM® DB2® LUW 10.5. Citrix XenApp v6.5 - Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Compare & Synch Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
DB2 LUW pureScale To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
DB2 LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
DB2 z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
DB2 z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
DB2 z/OS Dynamic Statement Cache The statements in the Dynamic Statement Cache (DSC) can now be viewed in Toad. IBM DB2 uses the DSC as a memory pool area to store SQL statements (SELECT, MERGE, UPDATE, INSERT, DELETE) that may be executed multiple times across different packages, plans and threads in Toad. Storing reusable statements in the DSC helps to improve performance as SQL preparation processes are reduced.
Space Management With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).

5.0 added these features (Click "+" to view) Business Value
What you gain when you upgrade to the current version 6.2
Toad for DB2 Base Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
DB2 LUW v10 Support Provided support the newest features from IBM for LUW such as new clustering options, hidden columns, static compression, and index sampling.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Professional Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
Data Compare Enhancements New, faster data comparisons including advanced column mapping, search, and improved navigation of differences.
DB2 LUW v10 Support Provided support the newest features from IBM for LUW such as new clustering options, hidden columns, static compression, and index sampling.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Toad for DB2 Xpert Edition (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
Data Compare Enhancements New, faster data comparisons including advanced column mapping, search, and improved navigation of differences.
DB2 LUW v10 Support Provided support the newest features from IBM for LUW such as new clustering options, hidden columns, static compression, and index sampling.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Integration to SQL Optimizer A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
SQL Optimizer for DB2 LUW Support added for IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012. Support for recommending Indexes for a single SQL statement
DB Admin Module Add-On (Click "+" to view) Business Value
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Compare & Synch enhancements Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
HADR Support Toad provides functionality to allows to work with High Availability Disaster Recovery (HADR) feature that provides overall stability and protection against the hardware, software or network failures. Synchronizing primary and standby servers guarantees the safety of your data.
IBM pureScale Support To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
Space Management enhancements With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Security Administration Toad significantly improved security administration support. All IBM DB2 supported security objects are now gathered under Security node in the Object Explorer and include the following new objects: With a help of new security objects it is possible to create a table with protected rows and columns using Security Labels and Policies. You can set security policy either in the script editor mode or with DOE (General page). Set the security labels in the Columns page in DOE.
z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.
Toad Development Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
Data Compare Enhancements New, faster data comparisons including advanced column mapping, search, and improved navigation of differences.
DB2 LUW v10 Support Provided support the newest features from IBM for LUW such as new clustering options, hidden columns, static compression, and index sampling.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Integration to SQL Optimizer A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
SQL Optimizer for DB2 LUW Support added for IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012. Support for recommending Indexes for a single SQL statement
Benchmark Factory Supports Windows 8 and Windows 2012. Support for the TPC-E benchmark using IBM DB2 Call Level Interface (CLI). Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include. Improved Benchmark Factory Runs Reports-Benchmark Factory Run Reports has been improved to provide easier access to test results tables and graphs. Import and Export of Test Results-You can now import and export test results form Run Reports. Increased Benchmark Loading Speed-Benchmarks used in the database testing process now load faster to reduce the database testing time.
Toad Data Modeler Support for DB2 10.5 (LUW)
Toad DBA Suite for DB2 (Click "+" to view) Business Value
Expose Data Sharing Name Hovering on a tab for a z/OS connection will now also show the data sharing member name.
DBA Healthcheck Dashboard Provides a single point overview of database administration data such as invalid objects and non-enforced constraints
Compare DDL file to live objects Object compare has been extended to support comparing one live object to another but also to DDL in a file.
Visual Database Map - Launch from SQL Editor Toad can now parse complex SQL and display referenced DB2 objects from SQL in the SQL Editor or Query Builder
Toad Intelligence Central Integration Toad users can shared Toad artifacts via the Toad server.
Library Organize and filter your files by tag name
Set passwords for multiple connections Toad's Connection Manager now supports the ability to update all your connection passwords in a single action.
File Version Control Toad supports direct file versioning to Subversion
Team Foundation Server via Team Explorer 2008
Team Foundation Server via Team Explorer 2010
Team Foundation Server via Team Explorer 2012
ALTER Table – new impact analysis Alter Table Editor now shows all of the database objects that will be affected by the alter so the user can make an informed decision on whether to apply the changes or not.
Data Compare Enhancements New, faster data comparisons including advanced column mapping, search, and improved navigation of differences.
DB2 LUW v10 Support Provided support the newest features from IBM for LUW such as new clustering options, hidden columns, static compression, and index sampling.
DB2 LUW 10.5 support Support added for PureScale, index key expressions, Null Keys can be specified when creating or altering indexes, Support for ORGANIZE BY COLUMN\ROW clauses for Tables, and ORGANIZE BY COLUMN\ROW clauses for Tables.   Support for IBM DB2 LUW 10.5 DB and DBM Parameters
DB2 z/OS v10 Support When converting a z/OS segmented tablespace that contains a single table to Partition-by-growth tablespace a deferred ALTER is generated instead of extended ALTER. Provided support the newest features from IBM for LUW such as hash organization and new SQL Table functions
DB2 z/OS 11 support Toad now fully supports Variables introduced in IBM DB2 on z/OS 11.   Dependencies of Array Types on z/OS 11 can now be easily viewed and accessed via a new tab in Object Explorer.   Toad for IBM DB2 now supports Compatibility mode and ENF mode. Toad for IBM DB2 now supports new z/OS 11.1 statement ALTER Table DROP COLUMN Clause.   Support for PCT FREE FOR UPDATE clause of CREATE TABLESPACE statement of IBM. The utility editors now support new Utility Statement syntax (LOAD, REBUILD INDEX, REORG INDEX, REORG TABLESPACE, REPAIR, RUNSTATS, and UNLOAD) of IBM DB2 z/OS 11.1
z/OS 11. Toad for IBM DB2 supports new IBM DB2 Archive table feature.   Toad for IBM DB2 now supports Array Types in IBM DB2 on z/OS.
DB2 z/OS Connections Toad now allows to set isolation level both on LUW and z/OS environments. Cursor stability, uncommitted read, read stability, and repeatable read are supported.
DB2 z/OS – multiple alter support Toad now supports the ability to alter multiple DB2 z/OS objects in a single operation.
Explain Plan improvements Respective section of SQL script is now highlighted after selecting a tab in Explain plan.
Oracle vector compatibility Toad implemented Oracle vector support of PL/SQL Triggers, PL/SQL Packages and enhanced support of PL/SQL Procedures & Functions. You can not only create new packages, alter and drop existing packages, but also see the script and edit PL/SQL Package privileges.
Java jar objects Toad now supports viewing and managing JAR objects within the object explorer.
QMF query support Toad now supports viewing, tuning and executing QMF queries from within the database explorer
Visual Database Map Similar to an ERD (entity relationship diagram) but more powerful because it will display all objects and not just those with referential relationships. So, any object that would be displayed in Toad’s database object browser will be visually mapped for the user whereas an ERD would only show tables, indexes, etc. 
Remove DB2 Connect Toad no longer ships a DB2 connect client making it easier to connect to your DB2 databases. In case Toad had not been installed before it offers you to create Toad connections profile out of the DB2 catalog. Connections can be created in a hierarchical fashion or in a flat tree view.
SQL Editor improvements System datatypes are now supported. These objects can be used in Editor in several places such as in variable declarations, function returns statements, and function/procedure parameters. Code completion now offers parameters of Functions and Procedures during writing of the code of their body. DOEs for Functions and Procedures have been enhanced and now parameters can be defined directly in the body of the procedure. Functions and Procedures now support DECLARE cur CURSOR FOR, OPEN, FETCH FOR, FETCH FOR cur INTO and CLOSE statements.
SQL Statement syntax error reports Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
UI enhancements UI has been improved and enhanced. New large buttons for the most often used functions. Icons now open in context to the feature being used.
Integration to SQL Optimizer A button "Tune the current statement" (z/OS) or "Optimize the current statement" (LUW) in Editor starts
SQL Optimizer for DB2 LUW Support added for IBM DB2 10 and 10.5 for LUW. Faster process to generate an index - This version uses table statistics first to calculate table rows. The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance. Supports Windows 8 and Windows 2012.
SQL Optimizer for IBM DB2 z/OS SQL Optimizer for IBM® DB2® z/OS® is a powerful extension to Dell™ Toad™ for IBM® DB2® z/OS®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. SQL Optimizer for IBM® DB2® z/OS® maximizes the performance of your SQL statements to ensure they are performing as fast as possible. Support for Windows 8.0, Windows 8.1 and Windows Server 2012 - SQL Optimizer for IBM® DB2® z/OS® supports Windows 8, Windows 8.1 and Windows Server 2012. Support for recommending Indexes for a single SQL statement
Benchmark Factory Supports Windows 8 and Windows 2012. Support for the TPC-E benchmark using IBM DB2 Call Level Interface (CLI). Now you can easily include a Stream Test when creating a TPC-H workload in the New Job Wizard. After selecting the TPC-H test, select the Stream Test option and specify the number of streams to include. Improved Benchmark Factory Runs Reports-Benchmark Factory Run Reports has been improved to provide easier access to test results tables and graphs. Import and Export of Test Results-You can now import and export test results form Run Reports. Increased Benchmark Loading Speed-Benchmarks used in the database testing process now load faster to reduce the database testing time.
Toad Data Modeler Support for DB2 10.5 (LUW)
Spotlight on IBM DB2 LUW Support for IBM® DB2® LUW 10.5 - Spotlight™ on IBM® DB2® LUW now supports IBM® DB2® LUW 10.5. Citrix XenApp v6.5 - Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Compare & Synch enhancements Various options for Compare Object were added: Ignore CCSID differences is now supported for all objects; Ignore COMPRESS keyword; Ignore tablespace differences; Ignore COLLECT STATISTICS differences for Indexes; Ignore range partition value differences option. New large Compare button groups all compare functions and makes it easier to access them quickly. New advanced option Ignore Table Organization is available in Compare Object, which causes Toad to ignore ORGANIZE BY clause. Create transformation rules with wildcards and regular expressions (.NET regular expressions are supported). With their help you can map several object pairs using one transformation rule. Select a type of transformation rule (= simple, > wildcard or >> regular) and specify a rule.
DB2 Configuration Parameter Compare Toad provides a convenient way to review, compare and synchronize DB/DBM parameters for LUW Databases.
DB2 LUW real-time stats A new tab Real Time Statistics was added to Database Viewer in Object Explorer. Statistics for Tables, Indexes and Tablespaces can be displayed.
HADR Support Toad provides functionality to allows to work with High Availability Disaster Recovery (HADR) feature that provides overall stability and protection against the hardware, software or network failures. Synchronizing primary and standby servers guarantees the safety of your data.
IBM pureScale Support To view detailed information about pureScale members on Linux databases, select a database in Database explorer and go to Members tab.   Automatic refresh interval can be set in seconds or set to 0 for continuous refresh. The following information is displayed about the host and every member: CPU usage; Memory and virtual memory usage; Packets/bytes sent and received;   Memory swap and others; Possible alerts are shown and indicated visually.
LUW Diagnostics log reader Use the new diagnostic log reader to filter and display LUW Database events
Space Management enhancements With new and enhanced Space Usage feature it is now possible to:   Predict space usage over given periods of time and at given point in time; Identify the moment when database runs out of space; Specify various settings to obtain more precise results; Visualize the information by comprehensive diagrams. The   Space Usage feature allows users to monitor tables, indexes and tablespaces. Click an object and select Space Usage tab. The feature provides information on space allocated (see "Current Usage" subtab). With a help of this tool you can monitor data growth and find out details. The result is presented into customizable bar chart or diagram (see "Growth" subtab).
Security Administration Toad significantly improved security administration support. All IBM DB2 supported security objects are now gathered under Security node in the Object Explorer and include the following new objects: With a help of new security objects it is possible to create a table with protected rows and columns using Security Labels and Policies. You can set security policy either in the script editor mode or with DOE (General page). Set the security labels in the Columns page in DOE.
z/OS – zParm display The system parameters of z/OS Subsystems are now displayed in the Object Details | System Parameters Tab.
z/OS Utilities (z/OS) You can run CHECK LOB utility on LOB tablespaces to ensure that there are no invalid LOB values. LOBs over 32Kb can be UNLOADed using SPANNED clause.