Welcome to IDERA DB Optimizer™ 17.0

DB Optimizer Home | DB Optimizer Documentation | IDERA Technical Support | www.idera.com

ReadMe Last Published: December 11, 2017. Any updates to these notes will be available at www.idera.com/support/productdocuments.


Thank you for using IDERA DB Optimizer, an enterprise SQL development and optimization tool that gives database developers and administrators the perfect environment for building the best performing SQL code. This application easily identifies inefficient SQL code and boosts developer productivity by ensuring SQL is right before it becomes a problem in mission-critical applications. DB Optimizer also provides a rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools. Lastly, DB Optimizer provides advanced project and data source management tools.

What's New in DB Optimizer

Updated Licensing

Updated Installer

Removed auto-Update and Install New Software features from Help Menu

Requirements

Hardware Requirements

Supported Operating Systems

Other Requirements

DBMS Support

SQL Execution, Tuning and DBMS Support

SQL Profiling and DBMS Support

Release Notes

Upgrade Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your IDERA Product

IDERA Product Support

IDERA Technical Support

IDERA on the Web

What's New in DB Optimizer

Updated Licensing

DB Optimizer includes a new licensing process to bring it into standard with the rest of the DB PowerStudio products.

Updated Installer

The installer for DB Optimizer now:

·        Verifies that a supported version of windows OS exists on the machine before continuing with the installation

·        Offers offline .MSI files for installation

Removed Auto-Update and Install New Software features from Help Menu

This version of DB Optimizer includes an updated Help menu that no longer includes Auto-Update and Install New Software options.

Requirements

Before installing IDERA DB Optimizer, verify that your environment meets the following requirements.

Hardware Requirements

The following are the minimum hardware requirements:

Supported Operating Systems

DB Optimizer is supported on the following operating systems (32- and 64-bit):

DBMS Support

SQL Execution, Tuning and DBMS Support

SQL execution and SQL tuning with DB Optimizer is supported on the following DBMS platforms and versions:

SQL Profiling and DBMS Support

SQL profiling with DB Optimizer is supported on the following DBMS platforms and versions:

* For these databases, DB Optimizer supports a subset of this database version’s features/functions.

Note: DB Optimizer does not access the information, tables, or views licensed under Oracle's diagnostic pack.

Release Notes

Upgrade Notes

Known Issues

Bug

Description

DBMS

OPT-5119

“Validation errors” in SQL EDITOR page in Oracle 11g, SQL Server 2014

Oracle / SQL Server

Bug Fixes

Customer-reported bugs fixed for the DB Optimizer 17.0 release:

Bug

Description

DBMS

OPT-5145

SQL Filters/Zero objects are always shown after applying SQL filter for Sybase.

Sybase

OPT-5144

DB2 for LUW – error on database objects population when data source is registered using alias from IBM client.

DB2

OPT-5143

Oracle/Tuning – Schema drop down is not getting populated when changing data source to not connected one

Oracle

OPT-5139

Data Source Explorer\Database objects naming is not consistent in DBPS products

 

OPT-5135

Data Source Explorer\Context help could not be found when creating a new data source group

 

OPT-5125

“synonyms getting executed few times when having ambiguous error” in Oracle 11g

Oracle

 

Customer-reported bugs fixed for the DB Optimizer 16.6 release:

Bug

Description

DBMS

OPT-4979

Error: No authorized routine named

DB/2

 

There are no bug fixes included in DB Optimizer 2016+ (16.5).

 

Customer-reported bugs fixed for the DB Optimizer 2016 (6.3.3) release:

Bug

Description

DBMS

OPT-3720

TS: Support for MSSQL 2012.

SQL Server

OPT-3935

Cannot generate pdf reports on Linux.

All

OPT-3972

"An unexpected token "as" was found. Expected RPAREN.

Oracle

OPT-4085

TS: Add support for OS authentication for Oracle when the authentication is NTS.

Oracle

OPT-4128

Support for Sybase 15.5.

Sybase

Additional Resources

Licensing Your IDERA Product

All IDERA products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the Quick Start Guide. If you have not yet purchased this product, contact sales@idera.com.

IDERA Product Support

The IDERA Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the IDERA Knowledge Base. Visit www.idera.com/support, or click any of the links below, to find:

IDERA Technical Support

If you have a valid maintenance contract with IDERA, the Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of IDERA products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Customer Support Center. For additional information about IDERA Technical Support, visit the Support section of our Web site.

IDERA on the Web

To download evaluations of other IDERA products or to learn more about our company and our products visit us at www.idera.com.