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 in v6.5?
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

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1176
How to turn off auto commit and add commit / rollback buttons to toolbar (93884)

How to turn off auto commit and add commit / rollback buttons to toolbar. You can switch off autocommit by clicking at the bottom left of Toad for DB2 window. If you don't see status bar at the bottom then right click to the right of the main menu and check 'status bar'. ...

Product(s): Toad for DB2
Last Updated On: 5/30/2018
(0 Ratings) 6230 views
Generate report in Compare feature within Toad does not provide all the objects that are different. (256256)

Generate report in Compare feature within Toad does not provide all the objects that are different. WORKAROUND: None. STATUS: Waiting for a fix in a future release of Toad for DB2.

Product(s): Toad for DB2
Last Updated On: 5/23/2018
(0 Ratings) 3 views
How to customize the toolbar and menu options. Missing features or tools on the menu. (105698)

How can the toolbar and menu options be customized? Some tools aren't used so don't need to be in the toolbar or menu. Or a feature used often is not on the toolbar or menu, can this be added? RESOLUTION: Right click over the menu bar and choose "Customize". ...

Product(s): Toad Data Point, Toad for DB2, Toad for SQL Server
Last Updated On: 5/22/2018
(1 Ratings) 3473 views
Export Wizard takes a very long time (over 30 minutes) to export to a csv file (255915)

In v6.5 the Export Wizard takes a very long time (over 30 minutes) to export to a csv file, where the CLP command takes one second to export the same data to csv file. The issue is related to TDB-3602 1. Re-run the Export Wizard to export the required rows. ...

Product(s): Toad for DB2
Last Updated On: 5/21/2018
(0 Ratings) 1 views
Does not automatically connect when launching Spotlight or SQL Optimizer (255814)

When launching Spotlight on DB2 or SQL Optimizer for DB2 from Toad for DB2 the database connected in Toad does not automatically connect in Spotlight or SQL Optimizer. The connection method being used in Toad is a ...

Product(s): Toad for DB2
Last Updated On: 5/18/2018
(0 Ratings) 5 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: 5/7/2018
(1 Ratings) 12696 views
Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password? (80949)

Cannot or unable to login. What is the Toad password? Where do I get my login credentials? What is my username and password? The account is locked so it needs to be unlocked and the password reset. There is a prompt ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 5/4/2018
(2 Ratings) 15493 views
Conversion error during import into table with hidden column. (254436)

When there is a table with hidden column it is not possible to import data into it using Import Wizard. Conversion error appears at the end of the Import Wizard. WORKAROUND. None. SOLUTION. Waiting for a fix in a future version of Toad for DB2.

Product(s): Toad for DB2
Last Updated On: 4/27/2018
(0 Ratings) 1 views
Version Control System setup with Team Server Foundation error "TF31002: Unable to connect to this Team Foundation Server" (254115)

Product(s): Toad for DB2, Toad for SQL Server
Last Updated On: 4/13/2018
(0 Ratings) 12 views
PL/SQL code marked as invalid (253054)

Even if the PL/SQL code can be successfully executed against the Db2 database when DB2_COMPATIBILITY_VECTOR is set to ORA, in Editor the code is marked as invalid. An issue with the parser. WORKAROUND. It is possible ...

Product(s): Toad for DB2
Last Updated On: 4/9/2018
(0 Ratings) 3 views
Select all the indexes 1 by 1 (251875)

Under v6.2 under Runstats table, an option is needed to select all the indexes at once. Currently, you need to choose them 1 by 1. WORKAROUND: None. STATUS: Waiting for a fix in a future release of Toad for DB2.

Product(s): Toad for DB2
Last Updated On: 3/29/2018
(0 Ratings) 5 views
There are users that are not showing in the Users list (251754)

After creating a user, they are not showing in the Object Explore's list of Users. They are showing in the Schema list instead. Users with only a GRANT to a role do not appear. WORKAROUND: If possible, grant the user a Select to some table. ...

Product(s): Toad for DB2
Last Updated On: 3/29/2018
(0 Ratings) 10 views
User Requirements, Permissions and Restrictions for Running Toad against LUW and z/OS databases (251514)

The following describes the requirements, permissions and restrictions for users who launch and run Toad: A Windows Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to ...

Product(s): Toad for DB2
Last Updated On: 3/28/2018
(0 Ratings) 10 views
Toad truncates or deletes characters from the DDL create statement. (251474)

Toad chops off or removes characters from the DDL create script. Below is an example, it truncates "SET" to "T" in the following DDL. It happens in both "Trigger" script tab and generating DDL for the table. CREATE OR REPLACE ...

Product(s): Toad for DB2
Last Updated On: 3/28/2018
(0 Ratings) 8 views
IBM.Data.DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used. (250934)

Trying to create a TABLESPACE , one gets the error: IBM.Data. DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used. Stack trace: at IBM.Data.DB2.DB2Command ...

Product(s): Toad for DB2
Last Updated On: 3/26/2018
(0 Ratings) 14 views
Is it possible to combine optimization and SQL statement to get explain plan? (187021)

Is it possible to put optimization and SQL together and get the explain plan? ie. "set current query optimization = 7; select count(*) from table_a chr inner join V_tab1 chi on chr.CHIMP_ID = chi.ID inner join V_tab2 ch on chi.CHARG_ID = ch.ID where CHRG_col like '%test%'; ". ...

Product(s): Toad for DB2
Last Updated On: 3/15/2018
(0 Ratings) 865 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: 3/15/2018
(0 Ratings) 339 views
Data migration no longer produces files with IXF and DEL extensions (225680)

1. With the Load Utility unchecked in Preserve Data Method, a schema migration generates EXPORT scripts and the exported file is of type .IXF. The IMPORT script generated uses “Import” statements using file type of .IXF, but ...

Product(s): Toad for DB2
Last Updated On: 3/15/2018
(0 Ratings) 703 views
Not able to disable getting Email Digests through Toad World's settings window (245394)

Setting the values to 'Not Subscribed' on the Settings Email Digests tab in Toad World does not work. Once they are set, if you go back to the home page and then back into Settings, the values are back to 'Subscribed to weekly digest' and the digests keep getting sent. ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad...
Last Updated On: 3/6/2018
(0 Ratings) 597 views
Which version(s) of DB2 are supported? (14017)

Which are the supported version(s) of DB2 that can be use with Toad for DB2? Please review the Technical Documentation for full system requirements of the latest version of Toad for DB2. Toad for DB2 version 6.5. Database ...

Product(s): Toad for DB2
Last Updated On: 2/19/2018
(0 Ratings) 1748 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". CAUSE 1: FTP action was set to DOWNLOAD instead of UPLOAD. Since the file didn't exist on the remote server, an error was displayed. ...

Product(s): Toad Data Point, Toad for DB2
Last Updated On: 2/15/2018
(0 Ratings) 297 views
How to customize Settings, Connections and Licenses for Toad for DB2 MSI? (230877)

How to customize Settings, Connections and Licenses for Toad for DB2 MSI? Is a customized silent installation possible? Toad for DB2 uses the below files for the Settings and Connections: -Settings.xml -Connections.xml. These ...

Product(s): Toad for DB2
Last Updated On: 2/12/2018
(0 Ratings) 6 views
Who to contact to renew Support Maintenance Contract? (58244)

Who to contact to renew a Support Maintenance Contract? To renew your support maintenance contract, please contact the Customer Support Renewals department. One can Renew Support maintenance contract here.

Product(s): Code Tester for Oracle, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 2/8/2018
(0 Ratings) 6214 views
How to un-install the Quest Installer (240093)

How can the Quest Installer be un- intalled from a machine? 1) Go to Control Panel | Program and Features window. 2) Highlight the Quest Installer entry. 3) Click the Un-install button. You need to have all the Quest products ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad Data Modeler, Toad for DB2...
Last Updated On: 2/6/2018
(0 Ratings) 738 views
What is the ECCN (Export Control Classification Numbers) for Toad? (14018)

What is the ECCN (Export Control Classification Numbers) for Toad? The ECCN Number for the Toad family of products can be found on the Export Control page.

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 2/6/2018
(0 Ratings) 2905 views