SQL Optimizer for DB2 LUW. Unable to populate the Compare tab with SQL queries. (4221218)
Unable to populate or fill the Compare tab with SQL statements or queries. ... How to enter SQL statements in the Compare tab? ... The Compare tab is for comparing the Original SQL and Rewrites such as Alt1, Alt2, and so on.
How do I create additional sql statements to test against the original and alternats? (4238905)
How do I create additional sql statements to test against the original and alternates?
Unable to start SQL Optimizer. It hangs at the splash screen. (4301107)
It hangs at the splash screen. ... It also cycles 3 times (starts and closes) by itself. ... The Task Manager and the Alt + Tab functionality also show a task named "Drop Plan Table" or "Create Plan Table", but there is no window for it.
'Nothing to install. All products have been already installed' (4283263)
All products have been already installed' ... If the product was not installed properly before, the installer may mistakenly think that the product is currently on the machine, and hence showed this error.
How and where to download a trial version of Quest Products? (4308974)
The main product page for each product has the option to "Download Free Trial". ... Or go to the Trials page, look up the product, and download. ... 3. Navigate down the list to the product needed
Get "The Parser did not identify the text as a valid SQL statement" error showing plan or rewriting SQL (4249175)
When showing the plan or rewriting SQL for a query that contains a comment in the SQL body, the following error is received. ... Here is an example of SQL that gets the error: ... SELECT T.TABSCHEMA, T.TABNAME, T.CREATE_TIME, T.ALTER_TIME, I.INDNAME, I.COLNAMES, I.CREATE_TIME
SQL Optimizer license management on Citrix server - It just says license is invalid (4287494)
We have installed SQL Optimizer on a Citrix server where this application is published for all the users. ... When we followed regular installation instructions, we are having license issues as by default the license file is saved for single user profile.
SQL Optimizer crashing when copying access plan (4339605)
Details on recreating the issue: You might need to run thru the steps twice in row but with new query (one with ; and one without would do it). ... 1) Opened SQL Optimizer ... 2) Pasted a query into the Query window
Sql Optimizer does not recognize (+1) on the sql statement (4283114)
User optimized a SQL statement and got error: The Parser did not identify the text as a valid SQL statement. ... SQL0104N An unexpected token "END-OF-STATEMENT" was found following " ". ... DB2 does not support ‘(+)’ format in SQL
SQL Scanner is unable to scan the complete list of SQL statements (4262460)
SQL Scanner is unable to retrieve SQL statements from packages starting with DECLARE CURSOR like the following: ... FROM SYSTOOLS.ADMINTASKS ... Contact Quest Support to retrieve the patch. ... STATUS
'SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL state (4274279)
User tries to optimize a simple SQL statement and always gets error: 'SQL0901N The SQL statement failed because of a non-severe system error. ... Statement Concentrator (STMT_CONC) was set to LITERALS
Error message indicating trial license key has expired. (4226307)
Error message indicating trial license key has expired as a trial key is entered into Knowledge Xpert or the trial period is passed. ... Please contact Quest Software Sales in order to obtain a new or an extended trial key.
How to download Quest product for commercial from Quest website? (4268250)
How do I download Quest product for commercial from Quest website? ... 3. If you have a SupportLink account, log in. ... If you do not have one, click Registration and go through the registration process.
Slow Generate Indexes function (4283201)
User has used Quest SQL Optimizer for DB2 to generate indexes for a SQL statement. ... It took a long time and never get a result. ... However, she could run rewrite SQL option just 1 minute to complete.
Optimized SQL does not return the same result set as the Original SQL. (4278309)
When executing, the original query returns 2 rows and optimized query returns 0 rows. ... Auto Commit when finished editing has been checked. ... Turn off Auto Commit when finished editing. ... Click on File | Options | General | Result Set | Remove check mark at Auto Commit when finished editing.
Some icons are missing from the toolbar (4330005)
Some icons, such as the "Rewrite SQL" one, are not in the toolbar.
Keep getting Login dialog when trying to connect. It keeps prompting for username and password. (4304334)
The username and password are correct, but Toad does not seem to accept it.</p> Attempted connection to a z/OS database. ... This is not supported Standalone SQL Optimizer for DB2 LUW only supports connections to a db2 database on Linux, Unix and Windows.
Are user-defined temp tables permanently stored in the temp tablespace? (4243978)
Are user-defined temp tables permanently stored in the temp tablespace? ... Temporary tables only exist in your current session. ... In order to optimize a SQL statement that uses temporary tables, these tables need to be created in this session before you optimize.
'While attempting to access the installation files an error occurred: Network connectivity issues (4278701)
User tried to install SQL Optimizer for DB2 LUW, after accepting license agreement, it always gave error below: ... While attempting to access the installation files an error occurred. ... Possible causes of this error include:
'The Parser did not identify the text as a valid SQL statement.' (4274125)
User optimized for a SQL statement with function STRIP and got error: The Parser did not identify the text as a valid SQL statement. ... Quest SQL Optimizer for DB2 v 3.5 has not supported function strip
Download, Denial - Cannot download commercial executable of Toad (or another product) (4270495)
Unable to download commercial installer for latest version. ... After logging into Support Portal and trying to download Toad (or another product), the following scenarios can occur: ... Our records do not show a previous purchase or Support Maintenance contract for .
Installation Guide > View Batch Run Details
The Batch Run Details window displays a summary of the run time information for the SQL statement with each of the alternative indexes. ... The Batch Run Details window will appear after the batch run process is completed unless the Show details on next batch run checkbox in the Batch Run Details window is unchecked.
Release Notes > Parameter Marker Conversion
For some source code, the ? is used to define parameter markers, therefore to enable unique referencing we have changed the name so it is unique within the SQL statement. ... Original SQL statement
User Guide > Scan
The Jobs are automatically marked when they are added by the Add Jobs wizard. ... To mark a Job ... The red checkmark will be prefixed to the File / Database Object column. ... Multiple Jobs can be marked at a time.
User Guide > Syntax Highlight
Syntax highlighting changes the colors and attributes of the text in the SQL statement displayed panes, making it easier to quickly identify parts of the code. ... The text colors and attributes for syntax highlights can be defined within the Options window.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All