How to get assistance with issues regarding ToadWorld.com. (4234860)
How to get assistance with issues regarding ToadWorld.com. ... </p><p>If there are issues or questions about certain content found on ToadWorld, please feel free to submit comments for that page/article if the option is available and/or join the community discussion forums.
How to create an explain plan with Sql Optimizer on select from session table (4240835)
How do you create an explain plan with a select, containing a global temporary table? ... If you launch only the select request, SQL Optimizer will say that the session table does not exist. ... Go to: Tools | User Define Temp Table:
Sql Optimizer for DB2 got time out (4278592)
It ran for a while then error : SQL30081N A communication error has been detected. ... Communication function detecting the error ... It looks like the batch was terminated because the connection to database was lost.
Error, "The Parser did not identify the text as a valid SQL Statement" when performing SQL Rewrite (4234961)
Running a query that contains the 'With UR' statement in Toad for DB2 and it runs and will show an explain plan. ... However, sending the same query to the Optimizer for DB2 and performing a SQL Rewrite, the following error occurs:
Error "The license key is missing a specific product option" when entering license key (4307297)
The following message is displayed when entering a Toad for DB2 LUW key in Help | Licensing: ... "The license key is missing a specific product option. ... Some product functionality may me unavailable."
Will Spotlight on DB2 attempt "optimizer hints" during the query re-write process? (4329732)
I wanted to know whether the tool will attempt "optimizer hints" during the query re-write process.
SQL Inspect Report not showing entire SQL text (4268160)
The report in SQL inspect displays the start of the SQL and not the entire text. ... The remainder of the SQL text is displayed as .... ... The SQL text in the grid is limited to 255 characters. ... WORKAROUND
No version selector window appears on launch of Optimizer from within Toad. How to reset default. (4234367)
When trying to launch SQL Optimizer from within Toad, it does not give the version selector window that allows you to choose witch version of Optimizer to open. ... By default, Toad will open a prompt if there are mutltiple versions installed.
What is a "license number" and how to find the license number in Toad for Oracle. Invalid license number error. (4270658)
How can a Toad for Oracle or Toad family products license number be looked up? ... A license number is different from a license key. ... A license number is a sort of serial number that is used for account tracking.
How to purchase or buy Toad? How to acquire a Commercial license key for Toad? (4289355)
How to acquire a Commercial license key?
"The Explain table ADVISE_INDEX column '45' does not have the proper definition or is missing." (4278838)
Used an ID without sysadmin to run SQL Optimizer for DB2 and received, error: 'The Explain table ADVISE_INDEX column '45' does not have the proper definition or is missing. ... Table ADVISE_INDEX was not existed for ID which was running Optimizer.
Spring Framework - CVE-2022-22965 vulnerability (4294347)
If the application is deployed as a Spring Boot executable jar, i.e. the default, it is not vulnerable to the exploit. ... However, the nature of the vulnerability is more general, and there may be other ways to exploit it.</div><div></div><div><span style="font-size: 11pt;font-family: Calibri, sans-serif;color: black;background-position: initial;background-size: initial;background-repeat: initial;background-attachment: initial;background-origin: initial;background-clip: initial;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcve.mitre.org%2Fcgi-bin%2Fcvename.cgi%3Fname%3DCVE-2022-22965&data=04%7C01%7CEdgar.Ueno%40quest.com%7C3f66f912a3e848237dc508da164f9082%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637846828231918011%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Bo7M3KNRtpiUTyScwNLYrKdkUiXC29vNOjGLa2cJ2AU%3D&reserved=0"
How to switch DB2 client in SQL Optimizer for DB2? (4299294)
Quest SQL Optimizer for DB2 do not have its own function to switch DB2 client.
SQL Optimizer for DB2 not working when "Use plan table from SYSTOOLS" selected (4332467)
Check when using an OS user if it has a database schema map to it. ... RESOLUTION ... Waiting for a fix in a future release of Quest SQL Optimizer for DB2.
Getting "Invalid authorization key" when registering SQL Optimizer DB2 with my Toad key. (4284660)
I tried to register with my Toad key and got the error: ... WORKAROUND 1 ... It may change over time but as of SQL Optimizer for DB2 version 3.0.0 there should be a separate product key from SQL Optimizer for DB2.
The Explain table "xxx.plan_table", column "xxx" does not have the proper definition or is missing. (4323664)
Error shows after logging in: ... SQL0220N The Explain table "xxx.ADVISE_INDEX", column "NLEAF" does not have the proper definition or is missing. ... SQLSTATE=55002 ... Different version of the plan table definition.
"This type of SQL statement is not supported" when optimizing a valid SQL statement. (4234011)
When trying to optimize a statement, a "This type of SQL statement is not supported" error is given. ... From Toad the query is sent to optimizer, and from there, use the green arrow icon to optimize, but it never optimizes and just gives the error.
Does SQL Optimizer for DB2 LUW support DB2 11 and 11.1? (4252544)
Does SQL Optimizer for DB2 LUW support DB2 11 and 11.1? <p>WORKAROUND</p>None<br><br><p>STATUS</p><p>Issue fixed in version 4.3.1. The latest version of SQL Optimizer for DB2 LUW can be downloaded <a href="https://support.quest.com/sql-optimizer-for-db2-luw/4.3.1/download-new-releases" target="_blank">here</a></p> SOFUL-42
Does SQL Optimizer for DB2 LUW support Windows 2016? (4333854)
Does SQL Optimizer for DB2 LUW support Windows 2016? <p>WORKAROUND</p>None<p>STATUS</p><p>Issue fixed in version 4.3.1. The latest version of SQL Optimizer for DB2 LUW can be downloaded <a href="https://support.quest.com/sql-optimizer-for-db2-luw/4.3.1/download-new-releases" target="_blank">here</a></p> SOFUL-41
SQL Optimizer for DB2. How to assign a default schema name in my queries so I do not have to add (4290024)
How to assign a default schema name in my query statements so I do not have to add a prefix?</p> <p> ... The schema name can be changed or selected at the lower left part of the SQL Optimizer screen.
User does not have the required authorization or privilege to execute on "SYSTOOLS.EXPLAIN_GET_MSGS" (4225828)
What tables need to be set up to support SQL Optimizer for DB2 and Toad for DB2? ... The message and requirement noted is specific to the Option setting under File | Options | General - "use of plan table from SYSTOOLS" enabled.
Log4j Vulnerability CVE-2021-44228 (4273218)
Are Toad products affected by the Log4j vulnerability CVE-2021-44228? <p><strong>Toad for Oracle:</strong><br>Toad for Oracle does not use Log4j. Therefore this vulnerability does not affect the product.<br>Toad for Oracle uses OraLDAPClntNN.dll (where NN is oracle version number like 12, 18, 19, etc)</p><p><br>It's unclear if Oracle LDAP client this uses Log4j, but believe this is not the case. </p><p>Some more information about the exploit:<br>"An attacker who can control log messages or log message parameters can execute arbitrary code loaded from LDAP servers when message lookup substitution is enabled"<br><br>Toad doesn't use any log message lookup substitution. The only messages we get from LDAP are numeric error codes, and Toad does not use any lookup substitution on them, or anything else.</p><p><br><strong>Toad Edge:</strong><br>Toad Edge doesn't use Log4j 2, but does use Log4 1.2.17<br><br>The range for this particular security vulnerability (CVE-2021-44228) is Log 4j 2.x to Log4j 2.15.0-rc1<br>Also, Toad Edge is not a server based application. The attack needs to happen over HTTP(S) requests.<br><br><br><strong>Unaffected products:</strong></p><p>Toad for Oracle</p><p>Toad for Oracle Editions</p><p>Toad for SQL Server</p><p>Toad for DB2</p><p>Toad for SAP</p><p>Toad for Data Point</p><p>Toad Intelligence Central</p><p>Toad Data Modeler</p><p>Toad Edge</p><p>SQL Navigator</p><p>SQL Optimizer for Oracle</p><p>SQL Optimizer for SQL Server</p><p>SQL Optimizer for DB2 LUW</p><p>SQL Optimizer for DB2 ZOS</p><p>SQL Optimizer for SAP</p><p>Benchmark Factory for Databases</p><p>Code Tester for Oracle</p><p>Toad DevOps Toolkit</p><p></p><p>Spotlight on Oracle</p><p>Spotlight on SAP</p><p>Spotlight on DB2 LUW</p><p></p>
When launching Quest SQL Optimizer for DB2 getting message: "Questzostuning", "Product is only la (4265473)
The key that is driving Quest SQL Optimizer for DB2 is from a Toad for DB2 add-on. ... This will launch Quest SQL Optimizer and send the query into the application as well.
Partitioned tables not showing up on object list in SQL Optimizer (4289865)
When explaining a query in SQL Optimizer, if a partitioned table is touched by the SQL, that table (and its indexes, statistics, etc) doesn't show up on the Access Plan tab. ... This problem happened for any partitioned table.
Getting error "For using Quest SQL Optimizer for DB2, the DB2 client must be installed" (4335215)
Getting error "For using Quest SQL Optimizer for DB2, the DB2 client must be installed" when starting up the tool System Requirements are not met <p>RESOLUTION</p><p>Please install a DB2 LUW Client Software version 9 or higher.</p>
Associazione di nuovi prodotti
- Strumenti self-service
- Knowledge Base
- Notifiche e avvisi
- Supporto prodotti
- Download di software
- Documentazione tecnica
- Forum utente
- Esercitazioni video
- Feed RSS
- Contatti
- Supporto tecnico
- Visualizza tutto