SQL Optimizer for DB2 ZOS 5.6 - Release Notes

Release Notes

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

Release Notes

Wednesday, June 6, 2018

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

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

Known Issues

Currently known issues in SQL Optimizer:

Feature Known Issue Defect ID
Installation

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.

SOFDZ-390
Installation

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.

SOFDZ-544

Third Party Known Issues

Currently known third party issues in SQL Optimizer:

Feature Known Issue Defect ID
Installation

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.

SOFDZ-427

System requirements

Before installing SQL Optimizer, ensure your system meets the following minimum hardware and software requirements:

Platform 600 MHz minimum, 1 GHz recommended
Memory

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

.NET Framework

.NET Framework 4.0

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 release package contains the following products:

  1. Quest SQL Optimizer for IBM DB2 z/OS 5.6
  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.

Globalization

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

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.
自助服务工具
知识库
通知和警报
产品支持
下载软件
技术说明文件
用户论坛
视频教程
联系我们
获得许可 帮助
技术支持
查看全部
相关文档