In Toad® for IBM® DB2® 6.5 the following new features were implemented:
Object Details
Object Overview Tab Display information from several Object Details tabs at once. Add, remove and replace panes and add formatting aids such as labels and separators to further organize your Overview.
Grants Tab
A new Grants tab that displays any CREATE ROLE and GRANT ROLE statements for a selected role. Double-click a role in Object Explorer and select Grants.
Compare Object
Check Format object body before comparing in step 2 of Compare Object to make it easier to spot any differences.
Dashboard
- Now you can scroll your Live Query widget to left and right to display more columns as needed
- Both LUW and z/OS dashboards can now be shared between connections
LUW Specific Features
User Privileges
Cataloged global temporary tables are now displayed in User Privileges Editor
LUW Utilities
INPLACE clause is supported for LUW REORG
Space Management
- A new Object Detail tab is available, which lists unused indexes and their last used date
- Right-click an index in Object Explorer and select Space Management | Identify Exceptions
z/OS Utilities
- A new Object Details editor is available for z/OS Report utility
- Right-click a tablespace or an index in Object Explorer and select Utilities | Report
- New Object Details editors are available for z/OS Modify Recovery and Modify Statistics utilities
- Right-click a tablespace in Object Explorer and select Utilities | Modify Recovery/Statistics
Compare Object
New Advanced Option is available, check Generate DEFER for indexes to generate DEFER YES clause for indexes.
*******
Additional information relating to the new features in version 6.5 can be found in the Release Notes or in
the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and
screenshots)