Apr 16, 2019 5:29:38 PM by Jeff Podlasek
We are pleased to announce the 7.0 release of Toad for DB2 which went GA on April 15, 2019.
This Blog highlights many of the new features and enhancement introduced in Toad for DB2 v7.0.
The manner in which you can view your licenses has changed. There is now a control in the top right area of our window that you can use to manage your licenses.
If there are any information messages about your licenses, those will appear as you drop down that control – for example:
Toad now gives you the flexibility when establishing your database connections as you can now specify your own connection strings. Just choose the ‘Connection string’ option when creating a new connection and then enter your connection string values in the edit box as shown below:
If you are concerned about leaving around an SQL statements you may have executed within Toad, you can now disable our SQL Recall feature by setting the SQL Recall – Number of statements to display to zero:
Toad now allows you to specify different values for the ‘Number of Rows to initially fetch’ on the data tab and within the SQL Editor\Query Builder.
For ease of use - we also have a control on the SQL Editor menu that allows you to control the rows to be fetched without leaving the editor.
We also extended our SQL Editor features by now allowing you to specify if you want the selected word in the editor highlighted throughout the script. Below shows that new feature:
Toad now supports the Boolean column data type that was introduced in DB2 LUW v11.1.3
Nick Names are now supported in Code Completion in the SQL Editor:
When connecting to DB2 LUW via a ‘connection string’ we have identified issues with several dashboard widgets that obtain information from DB2 by calling IBM APIs. So now when you create a dashboard with a ‘connection string’ established DB2 connection, the dashboard widgets will be limited to those that work without interfacing with IBM’s APIs.
In our Automation feature you can now create z/OS Real-Time Statistics (RTS) Analysis reports that identify objects that are in need of maintenance.
We also added a Real-Time Statistics widget so you can view RTS information within a DB2 z/OS Dashboard.
We added ‘History’ tabs for z/OS Tables, Indexes and Tablespaces so you can quickly view statistics over time on your objects.
To further assist with your administration tasks, you can now generate and execute ACCESS DATABASE commands via a right-click action on Tablespaces.
For complete details on this new Toad for DB2 release view the release notes here.
This release of Toad for DB2 forms part of the Toad for DB2 2019 Edition release and comprises the following products (product enablement depends on which Toad for DB2 editions you have purchased):
If you already own Toad for DB2 and have a support & maintenance contract, upgrade your Toad DB2 here.
We would love to hear from you. Please give us your feedback in the Toad DB2 forums
Try Toad for IBM DB2 for free
Are you in a trial now or just learning about Toad for IBM DB2? Find out which edition is right for you with our Toad for IBM DB2 functional matrix.
Like what you’ve learned so far about Toad for IBM DB2, why not try it for free for 30 days?
Learn more about Toad for IBM DB2 so you can spend less time managing DB2 and more time innovating.
Data sheet: Toad for IBM DB2
Start a discussion about this blog in the Toad World® forum, Toad for IBM DB2 .
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Tags: Toad for IBM DB2
Written by Jeff Podlasek
Jeff Podlasek is currently a Senior Software Development Manager for the Toad for DB2 products at Quest. Jeff has more than 20 years of software development experience. He has developed products and managed development teams working on DB2 tools since the 1980s. Jeff is a regular contributor in the Toad for IBM DB2 forums.