We are pleased to announce the release of Toad for DB2 v6.2. This new version is now available for customers to download at SupportLink and for trial download at our Toad for DB2 product page on software.dell.com.
Toad for DB2 is a comprehensive solution to improve DBA and development effectiveness and productivity for DB2 LUW as well as DB2 z/OS. It follows the design of all our Toad-family solutions with features for both the Developer and DBA.
Let’s see what’s new in v6.2.
The new Dashboard feature provides DB2 LUW DBAs with an easy way to keep track of important events of their database. We’ve only implemented this for LUW (for now).
The Dashboard is fully customizable using widgets that work sort of like Windows 10 tiles. You can add, remove and reorder widgets.
We’ve included a number of widgets out-of-the-box including a custom-SQL widget that allows users to display any type of report they choose:
In addition to the individual dashboards that can be defined and customized for specific connections, Toad also supports a Summary Dashboard to display data about multiple selected connections:
A long-standing request from our users has been added with v6.2. You can now compare saved DDL scripts to objects in your database. The compare works the same as Toad for DB2’s object compare. The only difference is that instead of selecting a source object/schema, you can select one or more DDL files as the source:
While visiting with customers, we heard how many had the same requirements we have at Dell with regards to password management. New passwords have to be created every 30 days. Now, if you’re just doing that for your PC login or Outlook account that might not be too big a hardship. But what about if you manage thousands of databases? Having to update your password for each of those connections was a time intensive task. We heard you. Now, with v6.2 you can update the password for multiple connections in a single action. Just multi-select the connections, right-click and select Set Password. Potential hours of work has been reduced to seconds! You’re welcome
In v6.1 we added a new feature called the Visual Database Map. As a Developer or DBA it is important to understand the inter-dependencies your database objects have – so you can get a better understanding of what objects are related and important to other objects. The Visual Database map gives you the greatest insight to your system for all database object types.
There are several ways you can launch the new Visual Database Map. You can click on the new large toolbar icon or right-click on any object and select “Show on Database Map”:
And with v6.2, we’ve added the ability to launch the map from the SQL editor or the Visual Query Builder -- the idea is that you might have some really complex SQL (unlike my example below J) and you want to gain some insight into the objects being used in the SQL. By clicking on the Database Map icon on either toolbar, Toad will parse your SQL, pull out all references to database objects and send them to the database map for you:
A new method to organize your files has been added to Toad. This new Library feature can be quickly launched from the Toad toolbar:
Toad has had ways to help you organize files (Project Manager) but this new feature incorporate a powerful search and tagging mechanism. It’s easy to add items to the Library. Just click Add to Library and then browse to and select one or more files. Your file is added to the Library but remains in its original location (so no forced moving of files to get organized). As the number of files in your Library grows, use filter, group, and search features to easily find the files you need.
You can add topics and use them to group files. You can also add keyword tags to individual files and use these to filter, group, or search.
Lastly, you can even save and run your Toad automation scripts from the Library. Just right-click on the script and select Execute.
Toad Intelligence Central allows you to share your Toad files with other Toad users within your team. You can publish all Toad artifacts like SQL files, DDL scripts, connection files, database map plugins and more.
Click View | Toad Intelligence Central to access this new feature:
Toad Intelligence Central features a full-function Object Manager that enables you to perform basic operations with files stored on the TIC server:
Version Control can now be configured for all files that are handled in Toad, e.g. *.sql, *.tsm, *.tas etc. It is easy setup and to commit new changes or get latest revisions from the repository.
To setup File Version Control:
To configure a file for Version Control, right-click a file Tab and select File Version Control | Add file to working folder and save the file in your working directory
To work with versions:
In Toad Status Bar the following states can be displayed which makes it easy to check the status of a file:
Version Control status
The file is not added to version control.
The file is under version control and is synchronized with version control repository. No changes are detected.
The file is under version control and has been modified by user. The changes are stored in local database only and need to be synchronized with version control repository.
The file is under version control and has been modified in both local database and version control repository.
The file is under version control and has been modified in version control repository.
The file is under version control but for some reason its status cannot be determined (for example, you created a script in your local database while the script with the same name already exists in version control repository, or you upgraded to a higher version of Toad and configured version control for the same repository while you have some uncommitted changes in the database).
The file was under version control but it was dropped or renamed in local database and exists only in version control repository.
The list above touches on the new big features and changes. Some updates specific for DB2 z/OS users:
Toad for DB2 6.2 has a lot of great improvements. The list above covers most of the changes but be sure to check out the release notes for a complete list. If you have feedback on 6.2, we’d love to hear from you. Feedback can be posted in the discussion forum, in the comments area below this post, or email me privately at email@example.com.