# Toad for IBM DB2 v5.6 is Generally Available

**URL:** <https://forums.toadworld.com/t/toad-for-ibm-db2-v5-6-is-generally-available/29923>\
**Category:** Toad for IBM DB2\
**Created:** [April 25, 2014, 5:16am UTC](https://forums.toadworld.com/t/toad-for-ibm-db2-v5-6-is-generally-available/29923 "2014-04-25T05:16:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve\_Hilker](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/steve_hilker/32/223_2.png) [@Steve\_Hilker](https://forums.toadworld.com/u/Steve_Hilker)\
**Post date:** [April 25, 2014, 5:16am UTC](https://forums.toadworld.com/t/toad-for-ibm-db2-v5-6-is-generally-available/29923/1 "2014-04-25T05:16:43Z")

</div>

We are pleased to announce the release of Toad for DB2 v5.6. This new version is now available for customers to download at [SupportLink](https://support.quest.com/Default.aspx) and for trial download at [quest.com](http://www.quest.com/toad-for-db2/) and [quest.com](http://quest.com/products/toad-for-db2/).

This new release contains some new enhancements for both the LUW and Z/OS editions of Toad for DB2. Most notably is the inclusion of our SQL Optimizer for IBM DB2 for z/OS (Xpert and Dev Suite).

Other enhancements include:

**Toad for IBM DB2 LUW v5.6:**

- Added support for IBM DB2 LUW v10.5

- New **Members** right-hand-side tab displays pureScale member information

- Ability to specify a **Key Expression** when an index is created or altered

- **Null Keys** can be specified when creating or altering indexes

- Support for **ORGANIZE BY COLUMN\ROW** clauses for tables

- Improved **Table Editor** making it easier to work with columns  
**Toad for IBM DB2 z/OS v5.6:**

- Added support for IBM DB2 z/OS v11.1

- Integration of SQL Optimizer (available in Xpert Edition, Development Suite and DBA Suite)

- Support for Compatibility mode and ENF mode

- Supports new z/OS 11.1 statement **ALTER** table **DROP COLUMN** clause

- Ability to Add Storage to support **PCT FREE FOR UPDATE** clause statement in z/OS 11

- Improved **Table Editor** making it easier to work with columns  
A full list of new enhancements and resolved issued can be found in the [release notes](http://us-downloads.quest.com/Repository/support.quest.com/Toad%20for%20DB2/5.6/Documentation/ToadForDB2_Release_Notes_PDF.pdf)