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
Removed auto-Update and Install New Software
features from Help Menu
Requirements
DBMS Support
SQL Execution, Tuning and DBMS Support
SQL Profiling and DBMS Support
Release Notes
Additional Resources
What's New in
DB Optimizer
DB Optimizer includes a new licensing process to bring it into
standard with the rest of the DB PowerStudio
products.
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.
The following are the minimum hardware requirements:
DB Optimizer is supported on the following operating systems (32-
and 64-bit):
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
Bug |
Description |
DBMS |
OPT-5119 |
“Validation errors” in
SQL EDITOR page in Oracle 11g, SQL Server 2014 |
Oracle / SQL Server |
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
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 [email protected].
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:
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.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.