Thursday, July 11, 2019
These release notes provide information about the SQL Optimizer release.
SQL Optimizer is a powerful extension to Toad for IBM® DB2®. It validates database code and fully automates the manual and time-intensive process of SQL optimization to generate SQL alternatives and locate the most efficient SQL statement. SQL Optimizer maximizes the performance of your SQL statements to ensure they are performing as fast as possible.
SQL Optimizer for IBM DB2 z/OS 5.6.1 is a maintenance release with no new functionality.
|Resolved Issue||Defect ID|
|Optimizing SQL statements with JOINs now generates correct row count.||SOFDZ-614|
Currently known issues in SQL Optimizer:
|Feature||Known Issue||Defect ID|
If SQL Optimizer was installed in earlier versions and subsequently version 5.5 is installed and then uninstalled, some 5.5 files are not removed automatically.
Workaround: Uninstall earlier versions prior to SQL Optimizer 5.5 installation. or Remove any remaining 5.5 files.
If SQL Optimizer 5.0.0 or 5.5.0 is installed, then SQL Optimizer 5.5.1 is installed side-by-side and then you uninstall one of them, Toad cannot find the correct installed version anymore.
Workaround : Uninstall all versions of SQL Optimizer and then re-install the latest version.
Currently known third party issues in SQL Optimizer:
|Feature||Known Issue||Defect ID|
SQL Optimizer may fail to lauch for the first time after its installation if a previous version has been installed. This issue only happens with Windows Installer 4.5 environment.
Workaround: Launch SQL Optimizer again. This issue only appears with the first time launch.
Fix: Install Microsoft Patch 972397.
Before installing SQL Optimizer, ensure your system meets the following minimum hardware and software requirements:
|Platform||600 MHz minimum, 1 GHz recommended|
512 MB of RAM minimum, 1 GB of RAM recommended
Note: The memory required may vary based on the following:
|Hard Disk Space||150 MB hard disk space|
Windows Server 2008 R2
Windows 7 (32-bit and 64-bit)
Windows 8 (32-bit and 64-bit)
Windows 8.1 (32-bit and 64-bit)
Windows Server 2012
Windows Server 2012 R2
Windows 10 (32-bit and 64-bit)
Windows Server 2016
.NET Framework 4.0
Note: The .NET Framework Client Profile is not supported.
DB2 for z/OS 10, 11, 12
Internet Explorer 7.0 or later.
Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide).
Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Note: SQL Optimizer for IBM® DB2® z/OS® may work in virtualization environments other than the ones in which it was tested.
Quest SQL Optimizer for IBM DB2 z/OS 5.6.1 release package contains the following products:
Refer to the Installation Guide for installation instructions.
Get the latest product information, find helpful resources, and join a discussion with the SQL Optimizer for IBM® DB2® z/OS® team and other community members. Click here to join the SQL Optimizer for IBM® DB2® z/OS® community.
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.