Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

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 1178
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) 25 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) 2423 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) 21112 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
"Need more information to connect" window highlights the NAME field instead of the PASSWORD field (230344)

When the "Show connection dialog on startup" is NOT checked and a connection is double-clicked, where the password has not been stored, Toad 6.2 opens the "Need more information to connect" dialog and the cursor is positioned on the PASSWORD field. ...

Product(s): Toad for DB2
Last Updated On: 6/12/2017
(0 Ratings) 4 views
Does TOAD for DB2 software use JAVA? (96330)

Does TOAD for DB2 software use JAVA? No, Toad does not use Java. It is a .NET based application, and the z/OS components that run on the mainframe are written in Assembler, C and C++.

Product(s): Toad for DB2
Last Updated On: 6/12/2017
(0 Ratings) 1685 views
Does Toad for DB2 support DB2 11 and 11.1 version? (225483)

Does Toad for DB2 support DB2 11 and 11.1 version? 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: 6/12/2017
(0 Ratings) 357 views
How to use visual Database Map feature (155844)

As a Developer or DBA, it is important to understand the inter- dependencies that database objects have; to get a better understanding of what objects are related and important to other objects (not simply relationships between tables as is seen in ER Diagram). ...

Product(s): Toad for DB2 ZOS, Toad for DB2
Last Updated On: 6/9/2017
(0 Ratings) 8542 views
No space is being shown when viewing tablespaces for partioned table indexes (225545)

There seems to be some inconsistency when viewing space for partitioned table. When viewing the tablespaces, in the Object Explorer, which contain the indexes, the space shows 0. When viewing the tablespaces that contain the partitioned table it shows space. ...

Product(s): Toad for DB2
Last Updated On: 6/8/2017
(0 Ratings) 272 views
Properties for default WLM service Class SYSDEFAULTSUBCLASS are incorrect (230240)

The wrong Properties are shown for some of the default WLM Service Classes. Expand Service Classes | System Objects. The 7 default Service Classes are shown, each with their own Parent Service Class. There are 3 Service ...

Product(s): Toad for DB2
Last Updated On: 6/8/2017
(0 Ratings) 6 views
'Extract DDL' for a 'Before Insert' trigger does not include the full SQL for recreating the trigger. (214101)

In the Object Explorer, right-click a 'Before Insert' Trigger | Extract DDL does not generate the full create trigger script. ie It doesn't create the SQL that runs when Before Insert trigger is fired off. eg: Toad produces: SET CURRENT ...

Product(s): Toad for DB2
Last Updated On: 6/7/2017
(0 Ratings) 663 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/7/2017
(0 Ratings) 5443 views
SQL1460N The environment variable "SOCKS_NS" required for SOCKS server name resolution is not defined or not valid (65815)

User tried to connect to DB2 ZOS and got error: SQL1460NThe environment variable"SOCKS_NS" required forSOCKS server name resolution isnot defined or not valid. Ensure that you use the following for TSOconnections: lDB2 user ID for the DB2 subsystem. ...

Product(s): Toad for DB2
Last Updated On: 6/5/2017
(0 Ratings) 2796 views
ERROR [51002] [IBM][DB2] SQL0805N Package "ASMNETDB2x.NULLID.SYSSH200.XxXxXx" was not found (229996)

Attempting to connect to a new BD2 for z/OS subsystem database one may see the error: ERROR [51002] [IBM][DB2] SQL0805N Package "ASMNETDB2x. NULLID.SYSSH200.XxXxXx" was not found. The SYSSH200 is a CLI ...

Product(s): Toad for DB2
Last Updated On: 5/31/2017
(0 Ratings) 17 views
ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968. (122451)

Connecting to a LUW database with Toad for DB2 is proper. However, when trying to connect to az/OS database with Toad for DB2 returns: Database Error DB2 Database Error. ERROR [42968] [IBM] SQL1598N An attempt to ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2
Last Updated On: 5/22/2017
(1 Ratings) 7085 views
Unable to cancel running query from Toad (227112)

In Toad for DB2 v6.2.0.315, there is a problem when trying to cancel a running query, where the query does not cancel, and you have to end the Toad process to stop it. To replicate it: 1. Define in : Tools | Options | Database ...

Product(s): Toad for DB2
Last Updated On: 5/22/2017
(0 Ratings) 144 views
'Length cannot be less than zero' error when trying to connect to DB2 (147400)

After an installation of Toad for DB2, the following error appears when trying to connect to the database: 'Length cannot be less than zero' DB2 client version 10.5 and the user has full admin permission on the server. .Net 4.5 is installed. ...

Product(s): Toad for DB2
Last Updated On: 5/22/2017
(1 Ratings) 2238 views
Error with different DataBase (DB) name with giving DB name during connection (91677)

User connected to database MPALT01 from Toad for DB2 v 5.0. User got an error: "SQL30061N The database alias or database name "LENA960 " was not found at the remote node.". Connecting to MPALT01 but error shown LENA960. IBM issue. Please follow steps below: ...

Product(s): Toad for DB2
Last Updated On: 5/17/2017
(0 Ratings) 2044 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 Data Modeler, Toad for DB2, Toad for SQL Server
Last Updated On: 5/11/2017
(1 Ratings) 2146 views
DB2 Parameters tab shows the same values for different nodes (229220)

DB2 Parameters tab shows the same values for different nodes (in tabbed view). Eg DATABASE_MEMORY and LOGPATH. Side-by-side view display correct values. WORKAROUND: None. SOLUTION: Waiting for fix in a future release of Toad for DB2.

Product(s): Toad for DB2
Last Updated On: 5/9/2017
(0 Ratings) 46 views
Wrong syntax for partitioned tables after extended alter (229072)

When changing a column of a Table, which needs drop Recreate, the wrong DDL is generated and the Rows of the Second Partition can not be reloaded. The error received when reloading is. Maxvalue of the Partition is a Keyword ...

Product(s): Toad for DB2
Last Updated On: 5/9/2017
(0 Ratings) 73 views