Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - Release Notes

Release Notes

Release Notes

Quest SQL Optimizer for SAP ASE 3.9

Release Notes

Tuesday, July 31, 2018

Welcome to Quest SQL Optimizer for SAP ASE

SQL Optimizer contains the following features:

  • Identifies problematic SQL statements in database applications
  • Diagnoses SQL related performance bottlenecks with visual analysis of Adaptive Server’s performance metrics
  • Generates SQL alternatives to automatically locate the most-efficient SQL statement
  • Proposes new index candidates for a SQL statement and identifies performance effects of adding new indexes to the database
  • Analyzes the effect on performance when changing Adaptive Server configuration parameters
  • Preempts performance degradation before deploying applications to production or when upgrading Adaptive Server
  • Identifies unused indexes in the database to free up space and decrease maintenance
  • Integrates DDL generation for multiple SQL statements and an interface that allows the creation of scripts and execution of commands

New in This Release

Quest SQL Optimizer for SAP® ASE 3.9 is a maintenance release containing bug fixes and enhancements.

Known Issues

Feature Known Issue Defect ID
General

SQL Optimizer cannot terminate a database connection or an operation when the Adaptive Server transaction log is full. Thus, if the transaction log becomes full while you are using SQL Optimizer, the program may hang. This only happens if the Adaptive Server ‘abort tran log full’ option is set ON.

Workaround:

Dump the transaction log.

DUMP TRANSACTION database_name WITH TRUNCATE_ONLY

Or, you may set the Adaptive Server 'abort tran on log full' option to OFF. You must evaluate whether this is an appropriate setting for your database environment.

 
The “WITH INTO_OPTION” syntax in the INTO clause of a SELECT statement is not supported. ST45442

The information for some data types does not display when records are retrieved from the database. This occurs on the Data tab of the Database Explorer module, the Run Results window in the SQL Optimizer module, and on the Result panel of the SQL Worksheet module. The following table lists the data type's that do not display.

Datatype Results in Database Explorer (Data tab)
binary “Bytes” displays in the column.
varbinary “Bytes” displays in the column.
money Truncated to two decimals.
smallmoney Truncated to two decimals.
text “Memo” displays in the column.
unitext “Blob” displays in the column.
image “Blob” displays in the column.
timestamp “Bytes” displays in the column.
bigint When the integer is very large, it is converted to a float datatype.
ubigint When the integer is very large, it is converted to a float datatype.
unichar

Displays this error message; no data displays for the table:

Failed to retrieve data. … Field 'columnname' is an unsupported type.

univarchar

Displays this error message; no data displays for the table:

Failed to retrieve data. … Field 'columnname' is an unsupported type.

ST46470
Installation

If you did not uninstall the previous version of SQL Optimizer before you installed the current version, the following message displays when you launch the program:

"The feature that you are trying to use is on a network resource that is unavailable."

Click OK to try again, or enter an alternative path to a folder containing the installation package ‘QuestSQLOptimizer_Sybase_version.msi’ in the box below."

Workaround:

You must uninstall the previous version of SQL Optimizer, and then install the current version again.

ST72116
SQL Collector for Monitor Server Quest SQL Optimizer for SAP ASE may hang if you do not have the Monitor Server connection information correctly entered. Check the Help file for detailed information for setting up the Monitor Server connection.  
Run Result Time When you have a SQL statement with parameters, the time from the Run Result function may not correspond with the actual run time for SQL in your application due to the substitution of actual values for the parameters by the Run Result function.  
Preferences The Preference settings from versions of SQL Tuning prior to version 3.0 will not be transferred to the Preference settings for the current version. You must customize all the option settings once again.  
Analyzer modules In the Analyzer modules, if you rapidly click several times on the child node of an Analyzer you may receive an Access Violation error message or an "Error loading SQL. File may be lost or corrupted." error message. ST46539
XML Plan Structure and details of the XML plan vary according to which version of ASE to which you are connected.  
Database Explorer

Database Explorer displays the following error message if the connection to the Adaptive Server is lost, and repeated attempts are made to reconnect to the database:

Failed to connect to database.

Fatal error: in TISybDatabase.Logon

Workaround:

There is no workaround for this issue. SQL Optimizer must be restarted.

 
SQL Optimizer

After you have executed the SQL alternatives in the Batch Run or individually, the “mismatch with original SQL error” message may display in the Remarks column in the Run Time pane in the SQL Optimizer window. This message indicates that the alternative is not retrieving the same result set as the original SQL.

This message should indicate that the alternative is not “semantically equivalent” and therefore is not a correct SQL transformation for the original SQL statement.

However, in closely looking at the SQL alternatives that sometimes produce this message, it can be seen that the SQL alternatives are semantically equivalent to the original SQL statement and should be retrieving the same result.

There are two issues that cause this error. The first is caused by an issue in ASE 15.x when the forces (see the Optimization Preferences) are applied to some of the SQL alternatives and the result is that no records are retrieved from the database.

The second is caused by a similar issue in ASE 15.x when the COALESCE function is added to some of the SQL alternatives and the result is that no records are retrieved from the database.

Workaround:

You should disregard these alternatives.

 

National Language Support

Note: These problems only arise if you type characters in the national language. If you are using the national Windows environment and type English text, these problems do not arise.

The message "Failed to retrieve the query plan ..." is displayed when you 1) select "dump abstract plan" on the Optimization | Abstract Plan page of the preferences, 2) connect to a French language database, and 3) optimize a SQL statement that contains any of the French language characters that are not a part of the English language character set. ST46552
An "Invalid value for field column_name" error occurs when you have your Windows environment set to French and you execute a SELECT SQL statement that selects the data from a column that stores monetary values. ST46555
When the table name, column name, or other database object contains any of the French language characters that are not a part of the English language character set, the table, column, or database object is displayed in the SQL statement as "garbage" characters in the SQL Text pane. ST46485

System Requirements

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

Platform 1 GHz recommended minimum
Memory 1 GB of RAM recommended minimum
Hard Disk Space 100 MB hard disk space
Operating System

Microsoft Windows Server 2008 R2

Microsoft Windows 7 (32-bit and 64-bit)

Microsoft Windows Server 2012

Microsoft Windows Server 2012 R2

Microsoft Windows 8 (32-bit and 64-bit)

Microsoft Windows 8.1 (32-bit and 64-bit)

Microsoft Windows 10 (32-bit and 64-bit)

Microsoft Windows Server 2016

Additional Software

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

Microsoft Internet Explorer 6.0 or later

Database Server SAP ASE 15.5, 15.7, 16

Global Operations

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 supports any single-byte or multi-byte character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America.

Getting Started

Contents of the Release Package

The Quest SQL Optimizer for SAP ASE release package contains the following products:

  1. Quest SQL Optimizer for SAP ASE 3.9

  2. Product Documentation, including:
    • Installation Guide
    • Online Help

Installation Instructions

Refer to Quest SQL Optimizer for SAP ASE Installation Guide for installation instructions.

Product Licensing

Product Licensing

To register the trial or production version

  1. Install and launch Quest SQL Optimizer for SAP ASE
  2. Enter your License Key and Site Message to register your trial or commercial license
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating