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
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 Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1186
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 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)
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) 8024 views
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) 4890 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
INTERNAL - TOAD.EXE Crashed Production DB2 Instance (231149)

TOAD for DB2 6.3. In the TABLES window of the Object Explorer with a TABLE selected, I clicked the INDEXES tab, then selected the first index to view. I then arrowed down quickly thru the indexes. After 4 - 5 times moving hitting ...

Product(s): Toad for DB2
Last Updated On: 7/10/2017
(0 Ratings) 8 views
How and where to download a trial version of Quest Products? (21229)

How and where to download a trial version of Quest Products? Go to Quest. 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. 1. Go ...

Product(s): Toad for SAP Solutions, SQL Optimizer for SQL Server, Toad Data Point...
Last Updated On: 7/7/2017
(1 Ratings) 13668 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: 6/28/2017
(1 Ratings) 6220 views
Unable to connect to DB2 after upgrading to version 3.6 or above (134808)

Upgrading from Toad Data Point version 3.5 to 3.6 and migrating settings. There is a default DB2 Client installed - version 9.7. However, on double-clicking a DB2 connection, one of the following messages may occur: The alias ...

Product(s): Toad Data Point, Toad for DB2
Last Updated On: 6/27/2017
(0 Ratings) 4576 views
Get "Object reference is not set or something among those lines" error changing delimiter value (210407)

If a search is done, in the Options window, to find the Script Statement Delimiter option prior to it being changed, the following error is received. "Object reference is not set or something among those lines" WORKAROUND: Go ...

Product(s): Toad for DB2
Last Updated On: 6/20/2017
(0 Ratings) 725 views
Parameters are not updating in DB Parameters tab (205592)

When looking at the DB Parameters tab, the DB CFG parameters mon_rtn_data and mon_rtn_execlist are not updating. These parameters were added in DB2 V10.1. WORKAROUND: None STATUS: This issue is fixed in Toad for DB2 6.3. ...

Product(s): Toad for DB2
Last Updated On: 6/20/2017
(0 Ratings) 664 views
Is there a way to connect Toad for Oracle with DB2 database? (228098)

Is there a way to connect Toad for Oracle with DB2 database? WORKAROUND: Toad for Oracle only works with Oracle databases. If you want to connect to a DB2 database, Toad Data Point / Toad Intelligence Central or Toad for DB2 are the appropriate programs. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 168 views
Does Toad have a version that is supported on Mac? (26230)

Does Toad support the Apple Mac platform? Commercial versions of Toad do not formally support use on Mac. There is a new option for Mac users. Please check out Toad-Mac in the Toad World community. http://www. toadworld.com/products/toad-mac-edition/default.aspx. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/15/2017
(0 Ratings) 2705 views
System.FormatException Error "Input string was not in a correct format" on launching Toad (138051)

The following error occurs on launching Toad: System.TypeInitializationE xception. The type initializer for 'Quest.Toad.DB2.DB2ConnectionControl' threw an exception. Stack Trace: at Quest.Toad.DB2.DB2ConnectionControl ...

Product(s): Toad Data Point, Toad for DB2
Last Updated On: 6/14/2017
(0 Ratings) 4081 views
How to download a commercial software installer? Need installer by FTP or mail. (17322)

How to download a Commercial version installer from the Quest Support Portal? In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. Steps to download a commercial product: ...

Product(s): Toad Intelligence Central, Toad for SAP Solutions, Backup Reporter for...
Last Updated On: 6/14/2017
(0 Ratings) 23105 views
Automation FTP activity fails with "error FTP_1 The path is not of a legal form" (230385)

Automation script is run but fails on the FTP action: "error FTP_1 The path is not of a legal form". FTP action was set to DOWNLOAD instead of UPLOAD. Since the file didn't exist on the remote server, an error was displayed. Ensure that the correct FTP direction is set.

Product(s): Toad for DB2
Last Updated On: 6/13/2017
(0 Ratings) 3 views
'Security Administration' is missing from the list of Authorities displayed for Groups (230378)

In the Database Explorer, click on a User name. "Security Administration" is among the list of Authorities displayed. Next click on a group name. "Security Administration" is not in the list. When a group name is double-clicked ...

Product(s): Toad for DB2
Last Updated On: 6/13/2017
(0 Ratings) 4 views