# Toad for IBM DB2 **URL:** https://forums.toadworld.com/c/toad-for-ibm-db2/12.md [Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md) --- ## [Unable to see ddl or grants in scripts table in toad when connecting to db2 12.1 database](https://forums.toadworld.com/t/unable-to-see-ddl-or-grants-in-scripts-table-in-toad-when-connecting-to-db2-12-1-database/61757)
**Author:** [@anjali.j.george](https://forums.toadworld.com/u/anjali.j.george)\ **Replies:** 3\ **Last updated:** [July 23, 2026, 10:20pm UTC](https://forums.toadworld.com/t/unable-to-see-ddl-or-grants-in-scripts-table-in-toad-when-connecting-to-db2-12-1-database/61757 "2026-07-23T22:20:56Z")
users are getting below error when using the scripts tab in toad for viewing the ddl of a table in toad. -- Permissions are absent in the script due to errors. -- See exception log for details. Entries from exception … --- ## [Multifactor Authentication on Toad for DB2?](https://forums.toadworld.com/t/multifactor-authentication-on-toad-for-db2/61414)
**Author:** [@rodolphe.arnachellum](https://forums.toadworld.com/u/rodolphe.arnachellum)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 11:16am UTC](https://forums.toadworld.com/t/multifactor-authentication-on-toad-for-db2/61414 "2025-11-11T11:16:51Z")
Hello there , is the Multifactor Authentication possible to be used with Toad for DB2 ? For which version of Toad for DB2 is it eligible ? Kr Rodolphe --- ## [Debug issue "SET CLIENT DEBUGINFO" error](https://forums.toadworld.com/t/debug-issue-set-client-debuginfo-error/61391)
**Author:** [@joseph.warren2](https://forums.toadworld.com/u/joseph.warren2)\ **Replies:** 0\ **Last updated:** [October 23, 2025, 8:01pm UTC](https://forums.toadworld.com/t/debug-issue-set-client-debuginfo-error/61391 "2025-10-23T20:01:24Z")
This error happens in our SIC environment but not in our DEV environment. Steps: Set the dilimeter. Find the procedure. Right click on it and click “Alter Procedure…” Right click on it and click “Compile SQL Procedure… --- ## [SSL Connections not working when a database is cataloged](https://forums.toadworld.com/t/ssl-connections-not-working-when-a-database-is-cataloged/60911)
**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\ **Replies:** 0\ **Last updated:** [May 2, 2025, 4:39pm UTC](https://forums.toadworld.com/t/ssl-connections-not-working-when-a-database-is-cataloged/60911 "2025-05-02T16:39:35Z")
Only Connection string works, it seems that either Toad cannot read the catalog properly or the DB2 client is not properly configured. Can you enable an option like a checkbox to enable or enforce secure connection in T… --- ## [DB2 on IBM cloud requires an SSL connection](https://forums.toadworld.com/t/db2-on-ibm-cloud-requires-an-ssl-connection/47416)
**Author:** [@mwilcox1](https://forums.toadworld.com/u/mwilcox1)\ **Replies:** 6\ **Last updated:** [May 2, 2025, 4:16pm UTC](https://forums.toadworld.com/t/db2-on-ibm-cloud-requires-an-ssl-connection/47416 "2025-05-02T16:16:43Z")
We need to connect Toad Data Point to a Db2 service running on the IBM cloud. The DB2 service requires an SSL connection. Any ideas on how we can enable Toad to connect via SSL to my Db2 service ? Thank you --- ## [SQL Optimizer 'this type of SQL statement is not supported'](https://forums.toadworld.com/t/sql-optimizer-this-type-of-sql-statement-is-not-supported/42675)
**Author:** [@jeffery.dokos](https://forums.toadworld.com/u/jeffery.dokos)\ **Replies:** 4\ **Last updated:** [March 7, 2025, 2:48pm UTC](https://forums.toadworld.com/t/sql-optimizer-this-type-of-sql-statement-is-not-supported/42675 "2025-03-07T14:48:56Z")
My query runs in Toad fine, but will not run in SQL Optimizer. Says ‘this type of SQL statement is not supported.’ Can anyone tell me what the ‘offender’ is? There is no log, no other information as to what caused the… --- ## [Statement delimiter](https://forums.toadworld.com/t/statement-delimiter/60611)
**Author:** [@patrick.verboom](https://forums.toadworld.com/u/patrick.verboom)\ **Replies:** 0\ **Last updated:** [February 20, 2025, 9:57am UTC](https://forums.toadworld.com/t/statement-delimiter/60611 "2025-02-20T09:57:59Z")
Hello. I use Toad for db2 version 7.4.1.12. In the options I can change the statement delimiter from the default ";" to for example the "@". Question is, does a toad command (to use in the editor) exist to change it in … --- ## [Toad for DB2 v8.0 will be released Feb 10, 2025](https://forums.toadworld.com/t/toad-for-db2-v8-0-will-be-released-feb-10-2025/60411)
**Author:** [@Julie\_Hyman](https://forums.toadworld.com/u/Julie_Hyman)\ **Replies:** 1\ **Last updated:** [February 17, 2025, 7:37pm UTC](https://forums.toadworld.com/t/toad-for-db2-v8-0-will-be-released-feb-10-2025/60411 "2025-02-17T19:37:10Z")
The new release will contain the following: Platform Support​ updates -- Windows 2022​ -- Latest version of IBM DB2 for z/OS - Version 13​ -- Latest version of IBM DB2 for LUW - Version 11.5.9 ​ -- Latest version o… --- ## [Error during installation toad for db2 7.2](https://forums.toadworld.com/t/error-during-installation-toad-for-db2-7-2/58715)
**Author:** [@rami.hizmi](https://forums.toadworld.com/u/rami.hizmi)\ **Replies:** 1\ **Last updated:** [January 28, 2025, 4:45pm UTC](https://forums.toadworld.com/t/error-during-installation-toad-for-db2-7-2/58715 "2025-01-28T16:45:17Z")
Hi, The error in the log: 0x80070643, failed to execute MSI package What caused the error and how I can fix it ? Thanks, Rami Hizmi --- ## [Uninstall after Silent install](https://forums.toadworld.com/t/uninstall-after-silent-install/58788)
**Author:** [@mdoyle](https://forums.toadworld.com/u/mdoyle)\ **Replies:** 1\ **Last updated:** [January 28, 2025, 4:44pm UTC](https://forums.toadworld.com/t/uninstall-after-silent-install/58788 "2025-01-28T16:44:40Z")
I followed this guide to run a silent install of Toad for DB2 7.4.1.2. Now I need to uninstall it. However, there is no entry in Control Panel for Toad for DB2. How do I uninstall it? --- ## [TOAD upgrade question](https://forums.toadworld.com/t/toad-upgrade-question/58870)
**Author:** [@marcio](https://forums.toadworld.com/u/marcio)\ **Replies:** 1\ **Last updated:** [January 28, 2025, 4:37pm UTC](https://forums.toadworld.com/t/toad-upgrade-question/58870 "2025-01-28T16:37:27Z")
Hi there, I have a licensed Toad for DB2 version 5.30 installed on a Windows 7 PC. I want to update it to the latest version which should be the 7.2 or 3 if I'm right? I also want to upgrade the PC to Windows 10/11 N… --- ## [Toad Closes while attempting to Connect to Database](https://forums.toadworld.com/t/toad-closes-while-attempting-to-connect-to-database/60154)
**Author:** [@mojoala](https://forums.toadworld.com/u/mojoala)\ **Replies:** 11\ **Last updated:** [January 28, 2025, 4:31pm UTC](https://forums.toadworld.com/t/toad-closes-while-attempting-to-connect-to-database/60154 "2025-01-28T16:31:25Z")
When I click the "Connect" button, TOAD immediately closes. It closes randomly on FACTSTT3 and FACTSUAT. In order to open any of the others, I have to connect to one of the two listed above and then connect to the desi… --- ## [How to find end of week between 2 dates](https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429)
**Author:** [@ipeleva](https://forums.toadworld.com/u/ipeleva)\ **Replies:** 1\ **Last updated:** [January 14, 2025, 5:47pm UTC](https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429 "2025-01-14T17:47:58Z")
I need help please . How to find all end of weeks between 2 dates ( start date 20230101 and end date 20250131) end of weeks : 20230107, 20230114, 20230121 etc Thank you --- ## [Error Installing V7.1](https://forums.toadworld.com/t/error-installing-v7-1/60204)
**Author:** [@mojoala](https://forums.toadworld.com/u/mojoala)\ **Replies:** 1\ **Last updated:** [January 10, 2025, 4:41pm UTC](https://forums.toadworld.com/t/error-installing-v7-1/60204 "2025-01-10T16:41:54Z")
oops ExecutePackageComplete returned event status code: \[0x80070643\]. ToadforDB2\_7.4.1.12\_x64\_En.msi returned error code: \[0x80070643\], Package returned error message: \[Failed to configure per-machine MSI package… --- ## [Collapsing All the "Begins"](https://forums.toadworld.com/t/collapsing-all-the-begins/54305)
**Author:** [@mojoala](https://forums.toadworld.com/u/mojoala)\ **Replies:** 2\ **Last updated:** [November 5, 2024, 4:10pm UTC](https://forums.toadworld.com/t/collapsing-all-the-begins/54305 "2024-11-05T16:10:58Z")
Is there a shortcut or menu item that collapses all of the "BEGINS" ? We have DB2 files have numerous stored procedures. It would be nice to collapse the begins so we could scroll quicker thru them. --- ## [How to compare a list of tables in Toad for DB2LUW DBA Edition](https://forums.toadworld.com/t/how-to-compare-a-list-of-tables-in-toad-for-db2luw-dba-edition/60034)
**Author:** [@william.klein](https://forums.toadworld.com/u/william.klein)\ **Replies:** 0\ **Last updated:** [October 7, 2024, 1:58pm UTC](https://forums.toadworld.com/t/how-to-compare-a-list-of-tables-in-toad-for-db2luw-dba-edition/60034 "2024-10-07T13:58:33Z")
Is there way to import a specific list of tables that we wish to compare between to databases? We have a group of tables (2,874) in one database that we need to compare to the same tables in the replication database. We … --- ## [Permissions are absent in the script due to errors](https://forums.toadworld.com/t/permissions-are-absent-in-the-script-due-to-errors/59934)
**Author:** [@fminda](https://forums.toadworld.com/u/fminda)\ **Replies:** 0\ **Last updated:** [September 12, 2024, 3:31am UTC](https://forums.toadworld.com/t/permissions-are-absent-in-the-script-due-to-errors/59934 "2024-09-12T03:31:08Z")
Toad for Db2 LUW Following the recommendations of the CIS Center for Internet Security for Benchmark, I have proceeded to revoke the public permissions of several views of the SYSCAT schema, for example: REVOKE SELECT O… --- ## [Toad for DB2 7.4.1.12 (64 bit)](https://forums.toadworld.com/t/toad-for-db2-7-4-1-12-64-bit/59142)
**Author:** [@jspohn](https://forums.toadworld.com/u/jspohn)\ **Replies:** 1\ **Last updated:** [March 20, 2024, 8:47pm UTC](https://forums.toadworld.com/t/toad-for-db2-7-4-1-12-64-bit/59142 "2024-03-20T20:47:44Z")
So, I just got the trial version and I am trying to make to a connection to DB2 LUW. I have entered everything correctly, but when I click on Connection, the dialog blinks and then nothing, no connection, no error messa… --- ## [Command Line Connection and Automation Script](https://forums.toadworld.com/t/command-line-connection-and-automation-script/59095)
**Author:** [@TLCowart](https://forums.toadworld.com/u/TLCowart)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 1:55pm UTC](https://forums.toadworld.com/t/command-line-connection-and-automation-script/59095 "2024-03-13T13:55:24Z")
I'm using a Windows Batch file to execute Toad, and because the goal is to execute this batch file from a service account, that account has no connection information. Thus, I am trying to provide that connection informat… --- ## [Migrate Toad z/OS Components tables from non-UTS to UTS tablespaces](https://forums.toadworld.com/t/migrate-toad-z-os-components-tables-from-non-uts-to-uts-tablespaces/58856)
**Author:** [@dtaylor01](https://forums.toadworld.com/u/dtaylor01)\ **Replies:** 0\ **Last updated:** [January 25, 2024, 10:52pm UTC](https://forums.toadworld.com/t/migrate-toad-z-os-components-tables-from-non-uts-to-uts-tablespaces/58856 "2024-01-25T22:52:04Z")
When setting up Data Sharing in our shop and going through the Toad for DB2 zOS Components Installation steps on the z/OS side, I had to add to change the application compatibility in a few places as the INSTDDL script w… --- ## [Error during installation toad for db2 7.4.1](https://forums.toadworld.com/t/error-during-installation-toad-for-db2-7-4-1/58714)
**Author:** [@rami.hizmi](https://forums.toadworld.com/u/rami.hizmi)\ **Replies:** 0\ **Last updated:** [December 20, 2023, 11:37am UTC](https://forums.toadworld.com/t/error-during-installation-toad-for-db2-7-4-1/58714 "2023-12-20T11:37:20Z")
Hi, The error: Setup Wizard ended prematurely because of an error. Your system has not been modified. To install this program at a later time, run Setup Wizard again. Click the Finish button to exit the Setup Wizard … --- ## [How do you run a stored procedure from a script in Toad to test it?](https://forums.toadworld.com/t/how-do-you-run-a-stored-procedure-from-a-script-in-toad-to-test-it/58483)
**Author:** [@lcascio](https://forums.toadworld.com/u/lcascio)\ **Replies:** 1\ **Last updated:** [November 8, 2023, 11:26pm UTC](https://forums.toadworld.com/t/how-do-you-run-a-stored-procedure-from-a-script-in-toad-to-test-it/58483 "2023-11-08T23:26:02Z")
I don't know why this is so not straightforward. I do not want to use any Toad automation features nor the data binding dialogs. I just want to to my tests by running a script and seeing results in the regular editor w… --- ## [Extract DDL and Generate SQL Create not including DB2 z/OS role privileges](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293)
**Author:** [@dtaylor01](https://forums.toadworld.com/u/dtaylor01)\ **Replies:** 2\ **Last updated:** [October 26, 2023, 7:49pm UTC](https://forums.toadworld.com/t/extract-ddl-and-generate-sql-create-not-including-db2-z-os-role-privileges/58293 "2023-10-26T19:49:50Z")
When doing an Extract DDL with the Include Privileges option specified, we are not seeing the grants for Roles being returned in the DDL script. We also noticed that they don't show up when selecting the Generate SQL, Cr… --- ## [Explorer \> Database \> Utilities, Applications, Monitor tab are blank](https://forums.toadworld.com/t/explorer-database-utilities-applications-monitor-tab-are-blank/58286)
**Author:** [@chai.chounglee](https://forums.toadworld.com/u/chai.chounglee)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 7:54am UTC](https://forums.toadworld.com/t/explorer-database-utilities-applications-monitor-tab-are-blank/58286 "2023-10-09T07:54:21Z")
Toad for DB2 version: 7.4.1.12 (64bit) ID to use: db2inst1 After connecting to DB, under Explorer \> Schema \> Database, Utilities, Applications and monitor tabs, we cannot see any data. Since this is a Prod DB, it is i… --- ## [Unable to view Open Connections, Monitor Applications, Buffer Pool Hit Ratios and widgets in Dashboard](https://forums.toadworld.com/t/unable-to-view-open-connections-monitor-applications-buffer-pool-hit-ratios-and-widgets-in-dashboard/58285)
**Author:** [@chai.chounglee](https://forums.toadworld.com/u/chai.chounglee)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 7:17am UTC](https://forums.toadworld.com/t/unable-to-view-open-connections-monitor-applications-buffer-pool-hit-ratios-and-widgets-in-dashboard/58285 "2023-10-09T07:17:49Z")
Toad for DB2 version: 7.4.1.12 (64bit) ID i use: db2inst1 We are using direct connection or catalog connection in Toad for DB2, but we still unable to solve the following issue. After connecting to DB2 DB, under Dashb… --- ## [Special Character in CLOB data](https://forums.toadworld.com/t/special-character-in-clob-data/58225)
**Author:** [@tomperry6910](https://forums.toadworld.com/u/tomperry6910)\ **Replies:** 0\ **Last updated:** [September 27, 2023, 5:57pm UTC](https://forums.toadworld.com/t/special-character-in-clob-data/58225 "2023-09-27T17:57:11Z")
When running a select the CLOB data is being truncated when it encounters X'00'. Ran query with a replace statement and this returns the complete field. Is there option in TOAD to automatically return the complete field … --- ## [Explorer Schema](https://forums.toadworld.com/t/explorer-schema/58054)
**Author:** [@cat](https://forums.toadworld.com/u/cat)\ **Replies:** 3\ **Last updated:** [September 5, 2023, 5:02pm UTC](https://forums.toadworld.com/t/explorer-schema/58054 "2023-09-05T17:02:05Z")
Hi, I have to set the Schema under Explorer tab each time. How can I set so that it defaults to DB2 by default? Thank you. --- ## [Toad for DB2 - Profile data](https://forums.toadworld.com/t/toad-for-db2-profile-data/57985)
**Author:** [@cat](https://forums.toadworld.com/u/cat)\ **Replies:** 0\ **Last updated:** [August 15, 2023, 9:32pm UTC](https://forums.toadworld.com/t/toad-for-db2-profile-data/57985 "2023-08-15T21:32:55Z")
I am using Toad for DB2. I was wondering if there's an option to profile data? Under Help \> Toad Help \> Search \> Data Profiling, I found the following info: However, I don't see the profile in my Toad instance. Than… --- ## [2-char delimiter?](https://forums.toadworld.com/t/2-char-delimiter/57779)
**Author:** [@Dozalito](https://forums.toadworld.com/u/Dozalito)\ **Replies:** 4\ **Last updated:** [July 26, 2023, 10:22pm UTC](https://forums.toadworld.com/t/2-char-delimiter/57779 "2023-07-26T22:22:03Z")
Can you use TOAD to export to a CSV file using a 2-character delimiter between values such as |^ ? I currently use AQT which they are taking away and TOAD is one of the potential options they list as a possible replacem… --- ## [Add row number per condition](https://forums.toadworld.com/t/add-row-number-per-condition/57873)
**Author:** [@ipeleva](https://forums.toadworld.com/u/ipeleva)\ **Replies:** 0\ **Last updated:** [July 18, 2023, 4:09pm UTC](https://forums.toadworld.com/t/add-row-number-per-condition/57873 "2023-07-18T16:09:45Z")
Hello , I need to add the row number based on 2 fields in a table. Could you help please ? table data : col1, col2 , col3 0, data 1 , adata1 0, data 1 , adata2 0, data 1 , adata3 0, data 1 , adata4 0, data… [Next page](https://forums.toadworld.com/c/toad-for-ibm-db2/12.md?page=1)