Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for DB2 ZOS 5.6.2 - Release Notes

Release Notes

SQL Optimizer for IBM® DB2® z/OS® 5.6.2

Monday, June 1, 2020

These release notes provide information about the SQL Optimizer release.

About SQL Optimizer for IBM® DB2® z/OS®

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.

New in This Release

Updates to SQL Optimizer 5.6.2

SQL Optimizer for IBM DB2 z/OS 5.6.2 is a maintenance release with no new functionality.

Known Issues

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.


Third Party Known Issues

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.


System requirements

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:

  • Applications that are running on your system.
  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database
Hard Disk Space 150 MB hard disk space
Operating System

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

Windows Server 2019

.NET Framework

.NET Framework 4.6.2

Note: The .NET Framework Client Profile is not supported.

Database Server

DB2 for z/OS 10, 11, 12

Additional Software

Internet Explorer 7.0 or later.

Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide).

Virtualization support

Application Virtualization

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.

Getting started with SQL Optimizer

Contents of the Release Package

Quest SQL Optimizer for IBM DB2 z/OS 5.6.2 release package contains the following products:

  1. Quest SQL Optimizer for IBM DB2 z/OS 5.6.2
  2. Product Documentation, including:
    • Install Guide
    • Release Notes
    • Help

Installation Instructions

Refer to the Installation Guide for installation instructions.

Additional resources

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.

Product Licensing

To register the trial or production version

  1. Select Help | Licensing.
  2. Enter your Authorization key.
  3. Enter your site message if you have a Production key.
  4. Click Apply.
Outils libre-service
Base de connaissances
Notifications et alertes
Support produits
Téléchargements de logiciels
Documentation technique
Forums utilisateurs
Didacticiels vidéo
Flux RSS
Nous contacter
Obtenir une assistance en matière de licence
Support Technique
Afficher tout
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation