DB
Optimizer Home | DB
Optimizer Documentation | IDERA Technical Support
| www.idera.com
ReadMe
Last Published: August 19, 2019. 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.
WaRNING: DB Optimizer 17.0.1 and later cannot use any
workspaces produced by previous DBO versions, nor Use any files created by
those older workspaces.
What's New in DB Optimizer 17.0.4
Added Support for Latest SQL Server and Oracle
Versions
What's New in DB Optimizer 17.0.3
What's New in DB Optimizer 17.0.2
What's New in DB Optimizer 17.0.1
What's New in DB Optimizer 17.0.0
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 17.0.4
added
support for latest sql server and oracle versions
DB
Optimizer 17.0.4 adds support for SQL Server 2019 and Oracle 19c.
What's New in DB Optimizer 17.0.3
Fixed Issues
There are no new features in DB Optimizer 17.0.3. This release
does include a number of fixed issues that you may review in Bug
Fixes.
What's New in DB Optimizer 17.0.2
DB Optimizer 17.0.2 is simply an update to the version number.
What's New in DB Optimizer 17.0.1
Continued Licensing UPDATES
DB Optimizer 17.0.1 includes additional licensing updates to bring
it into standard with other IDERA products.
REDESIGNED Components
DB Optimizer 17.0.1 contains the following redesigned components
for a better user experience:
·
Main toolbar
·
Data Source tab
·
Project Explorer tab
·
Main window tab right-hand mouse options
SQL Server enhancements
DB Optimizer 17.0.1 offers a number of SQL Server-related
enhancements including:
·
The Tuning Statement window includes a drop-down list of schemas
when viewing SQL Server databases.
·
The DB Optimizer Profiler now properly displays SQL statement
detail.
·
Improved error messages.
What's New in DB Optimizer 17.0.0
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
The SQL Server sqlvariant
data type is not currently supported by the Microsoft JDBC driver. If a query is
used to retrieve data from a table that contains a column of the sqlvariant data type, an exception will occur. There are
two workarounds to fix this issue:
·
Use CAST to type cast the sqlvariant
columns to the data type you want.
Or
·
Use the jTDS driver to
connect.
Bug Fixes
There are no customer-reported bugs fixed in the DB Optimizer
17.0.4 release.
Customer-reported bugs
fixed for the DB Optimizer 17.0.3 release:
|
Bug |
Description |
DBMS |
|
OPT-5269 |
Trying to view “Using
DB Optimizer” web page causes an error |
All |
|
OPT-5270 |
Optimizer not
collecting “sql_statement” information |
Sybase ASE |
|
OPT-5273 |
Data source name
cannot exceed 30 characters in CM and DBO |
All |
|
OPT-5274 |
Install/config error: Driver not configured for integrated
authentication |
SQL Server |
There are no
customer-reported bugs fixed in the DB Optimizer 17.0.2 release.
Customer-reported bugs
fixed for the DB Optimizer 17.0.1 release:
|
Bug |
Description |
DBMS |
|
OPT-5017 |
SQL Editor problems do
not appear in Problems view |
SQL Server |
|
OPT-5082 |
Error log does not
show errors reported by tuning session |
All |
|
OPT-5086 |
SQL tuning session
cost color preference not working |
All |
|
OPT-5087 |
SQL tuning session
cost color preference also applies to elapsed time |
All |
|
OPT-5088 |
SQL tuning session
stops if the elapsed time is longer than the original |
All |
|
OPT-5097 |
SQL tuning session
offers obvious selection criteria for picking winner |
All |
|
OPT-5098 |
SQL tuning session
should highlight # winners found and % improvement |
All |
|
OPT-5103 |
DBO needs a priv grant wizard like DBArtisan’s
capacity analyst |
Oracle |
|
OPT-5106 |
Saving a tuning
session does not persist/save user selections |
All |
|
OPT-5121 |
“Tables/Views/Synonyms”
are not getting resolved in SQL Server and Sybase when it exists in schema
other than DBO |
SQL Server, Sybase |
|
OPT-5122 |
Sybase: table name is
getting resolved but not executed |
Sybase |
Customer-reported bugs
fixed for the DB Optimizer 16.6 release:
|
Bug |
Description |
DBMS |
|
OPT-4979 |
Error: No authorized
routine named |
DB/2 |
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, and discussion forums. Visit www.idera.com, 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.