Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

Toad for DB2 - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new v6.2
Video-Visual Database Map feature
Video-Compare Object feature
Video-Space Prediction functionality of Space Management
How to find the license number
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1193
'Syntax Checker' icon is disabled (233869)

Opened a sql file and tried the 'Syntax checker' but it's not enabled (grayed out) Not connected to a database at the time Connect to the database Note: There needs to be a commercial license for the DB2 platform in order to enable 'check syntax' ie If there is a DB LUW license ...

Product(s): Toad for DB2
Last Updated On: 10/19/2017
(0 Ratings) 9 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 10/18/2017
(1 Ratings) 7717 views
Cancelling a running query does not work (233167)

Steps to reproduce the issue: 1) Change database rows limit option of 1000 to apply to the editor (Tools | Options |Database | General). 2) Execute a sql statement that returns more than a 1000 rows in the editor using F9. 3) The ...

Product(s): Toad for DB2
Last Updated On: 9/26/2017
(0 Ratings) 6 views
Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values (233165)

Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values This message is a warning message (not error) that occurs when a column function is used in an expression. For example, "select sum(salary ...

Product(s): Toad for DB2
Last Updated On: 9/26/2017
(0 Ratings) 7 views
Toad crashes after clicking on the Application tab (232999)

The following error appears when going to Object Explorer | Databases | Application Tab 'Toad for DB2 no longer works A problem has prevented the correct execution of this program. Close the program.' In the ExceptionTrace ...

Product(s): Toad for DB2
Last Updated On: 9/19/2017
(0 Ratings) 5 views
After upgrading, an error appears that says "There is no DB2 catalog entry for this connection" w (87851)

After upgrading, an error appears that says "There is no DB2 catalog entry for this connection" when trying to connect in the new version. It does not happen with all connections, but it does happen for many of them. Cataloged connections are lost in the new Toad version. ...

Product(s): Toad for DB2
Last Updated On: 9/14/2017
(0 Ratings) 4044 views
Getting error "System.EntryPointNotFoundException 无法在 DLL“db2app64.dll”" when trying to connect (232739)

Getting error below when trying to connect to the database: System.EntryPointNotFoundException 无法在 DLL“db2app64. dll”中找到名为“SQLFreeConnAttribsADONET”的入口点。 Stack Trace: 在 IBM.Data.DB2.UnsafeNativeMethods ...

Product(s): Toad for DB2
Last Updated On: 9/8/2017
(0 Ratings) 29 views
It is possible to connect toad with ODBC to DSN though System Access driver? (96259)

It is possible to connect toad with ODBC to DSN though System Access driver? No.Toad for DB2 does not support ODBC.

Product(s): Toad for DB2
Last Updated On: 8/30/2017
(0 Ratings) 1629 views
Not possible to export table as xml file (232148)

Not possible to export a result as an XML file. It is blocked by license. In Toad for DB2 click on Help | Licensing and then check to "Add-Ons:" field. If the Db2 on Z/OS is used check if the ZOS DB Admin license is used. If the Db2 ...

Product(s): Toad for DB2
Last Updated On: 8/24/2017
(0 Ratings) 2 views
Getting error "DragDrop registration did not succeed" when starting up Toad Data Point (146130)

Getting error below when starting up Toad Data Point: "DragDrop registration did not succeed" and "ActiveX control '8856f961-340-11d0- a96b-00c04fd705a2' cannot be instantiated because the current thread is not in a single-threaded apartment". WORKAROUND 1: ...

Product(s): Toad Data Point, Toad for DB2, Toad for SQL Server
Last Updated On: 8/24/2017
(3 Ratings) 5883 views
Getting "You must enter a valid license and site message in order to continue" error when entering a valid license key. (157291)

When entering a valid license key into the installer, it thinks the key is invalid. The following message is given. "You must enter a valid license and site message in order to continue". The reason the license key is not being accepted ...

Product(s): Toad for DB2, Toad for Oracle
Last Updated On: 8/23/2017
(0 Ratings) 5032 views
[IBM][DB2/LINUXX8664] SQL1092N failed because the user ID does not have the authority to perform (232316)

IBM.Data.DB2.DB2Exception: ERROR [] [IBM][DB2/LINUXX8664] SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "E008099". ...

Product(s): Toad for DB2
Last Updated On: 8/23/2017
(0 Ratings)
Does Toad for DB2 support Mac? (227964)

Is it possible to use Toad for DB2 in a Mac environment? Toad for DB2 is not available for Mac environment.

Product(s): Toad for DB2
Last Updated On: 8/17/2017
(0 Ratings) 246 views
Toad installation gives a privilege or group policy error (69739)

The Toad installation may encounter one of the following errors: 1. ERROR: "You don't have the privilege to perform the installation. Please login as administrator to install the product.". or. 2. "The installation can't be completed. ". or. ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/16/2017
(2 Ratings) 8546 views
Toad for DB2 6.0 and newer, DB2 client requirements. Error: "Toad did not find a default DB2 client" (128114)

On launch of Toad for DB2, the error "Toad did not find a default DB2 client" is given. Toad will continue to open after clicking OK to this message, but there may be further issues connecting to the database. (Considering Toad ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2, Spotlight on DB2
Last Updated On: 8/16/2017
(0 Ratings) 8593 views
What kind of Db2 clients can be used with Toad for DB2 v6.3 (231574)

As the Db2 client is no longer distributed with the Toad for DB2, what kind of Db2 client should we use? Toad for DB2 works with IBM Data Server Client and IBM Data Server Driver Package. Both versions can be downloaded here (IBM Pages - Client version 11.1). ...

Product(s): Toad for DB2
Last Updated On: 8/16/2017
(0 Ratings)
Does Toad for DB2 support Windows 2016? (225423)

Does Toad for DB2 support Windows 2016? If not, when this will be supported? WORKAROUND. None STATUS. Issue fixed in version 6.3. The latest version of Toad for DB2 can be downloaded here.

Product(s): Toad for DB2
Last Updated On: 8/16/2017
(0 Ratings) 451 views
How to check if the userId which runs Toad belongs to DB2ADMNS and DB2USERS groups? (229314)

There are cataloged DB2 connections under the DB2 Command Line Processor. The command "list database directory" show entries. However, the Toad dialog don't populate the DB2 entries. The UserID which runs Toad needs ...

Product(s): Toad for DB2
Last Updated On: 8/15/2017
(0 Ratings) 16 views
ERROR: "Utility command failure: REORG TABLESPACE XXX.XXX Return code = 8" (228283)

When using the Reorg feature located on Tablespaces | right click a tablespace | Utilities | Reorg. The following error is received: Defect WORKAROUND: None. STATUS: The issue has been fixed on version 6.3 of Toad for DB2. Download the latest release here.

Product(s): Toad for DB2
Last Updated On: 8/14/2017
(0 Ratings) 9 views
How to find out who is using what license key in order to deactivate the user from the license? How to track the license keys? (105289)

How to find out who is using what license key in order to deactivate the user from the license. In the event of a Toad user leaving, how can the licensed key be tracked down and deactivated from the user. It is the responsibility ...

Product(s): Toad Data Point, Toad Data Modeler, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/9/2017
(1 Ratings) 5429 views
How to increase the font size for Connection Manager and Database Explorer (231847)

Currently, It's possible to change the font type and size for the Editor. However, it's not possible to change the font size in the Connection Manager or Object Explorer. Provide the ability to change font style and size. Try increasing the DPI in Control Panel | Display. ...

Product(s): Toad for DB2
Last Updated On: 8/3/2017
(0 Ratings) 7 views
Getting "...did not find a supported default DB2 client..." or DB2 SQL1598N "licensing error" when connecting. (128810)

Encounter error on launch and connection. Issue 1: On first launch of Toad the following message will be prompted: "Toad did not find a supported default DB2 client and cannot continue. Please shut down Toad, install a default ...

Product(s): Toad for DB2
Last Updated On: 7/26/2017
(1 Ratings) 6248 views
Message "no changes detected" when adding 'Select' privilege for User or Group, using 'Edit Table Privileges'. (231309)

When trying to grant a table privilege to a group/user via "Edit Table Privileges", a user/group is added, and grant Select access is checked. On clicking Show Script, it indicates "no changes detected". If the Insert privilege is ...

Product(s): Toad for DB2
Last Updated On: 7/14/2017
(0 Ratings) 4 views
Beta version shows expired and is not accepting license key. (80838)

When running a Beta version that was downloaded from http://www.toadworld. com . Upon launch, Toad prompts that it has expired. No other license key is accepted. (This applies to various products with a Beta version.). Beta ...

Product(s): Toad Intelligence Central, Toad for SAP Solutions, SQL Optimizer for SQL...
Last Updated On: 7/13/2017
(0 Ratings) 22283 views
Does Toad for DB2 include DB2 client ? (231209)

Does Toad for DB2 include DB2 client ? Starting with version 6.x Toad for DB2 doesn't include any more the DB2 client. Older versions of Toad for DB2 still provide the DB2 client but they don't support Windows 10. Toad for ...

Product(s): Toad for DB2
Last Updated On: 7/12/2017
(0 Ratings) 8 views