Toad Data Point 5.7 - User Guide

Welcome to Toad Data Point Understand Toad's Workflow

Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Troubleshoot DB2 LUW Issues

Review the following solutions to help troubleshoot DB2 LUW issues pertaining to Toad installation and database connections.

Installation Issues

Issue	Cause/Solution
System.IO.FileNotFoundException - File or assembly name DB2AdminWrapper, or one of its dependencies was not found	You are not a member of the DB2ADMIN or DB2USERS group. To install Toad, you must be a member of either group. Solution: Ensure that you have been added to one of these groups.
Error: "Could not load file or assembly 'IBM.Data.DB2.9.1.0, Version=9.1.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified."	You installed a commercial version of Toad for DB2 after uninstalling the freeware version. Solution: You must remove run time information for the freeware version of Toad from the .NET system.config file. To remove run time information Exit Toad. Navigate to the following .NET framework directory: C:\WINDOWS\Microsoft.NET\ Framework\v2.0.50727\ CONFIG Create a backup copy of the system.config file. Open the system.config file in Notepad. Locate the <runtime> tag delete everything between the runtime tags (including <runtime> and </runtime>). Save the file. Restart Toad.

Issue

Cause/Solution

System.IO.FileNotFoundException - File or assembly name DB2AdminWrapper, or one of its dependencies was not found

You are not a member of the DB2ADMIN or DB2USERS group. To install Toad, you must be a member of either group.

Solution:

Ensure that you have been added to one of these groups.

Error: "Could not load file or assembly 'IBM.Data.DB2.9.1.0, Version=9.1.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified."

You installed a commercial version of Toad for DB2 after uninstalling the freeware version.

Solution:

You must remove run time information for the freeware version of Toad from the .NET system.config file.

To remove run time information

Exit Toad.
Navigate to the following .NET framework directory:
C:\WINDOWS\Microsoft.NET\
Framework\v2.0.50727\
CONFIG
Create a backup copy of the system.config file.
Open the system.config file in Notepad.
Locate the <runtime> tag delete everything between the runtime tags (including <runtime> and </runtime>).
Save the file.
Restart Toad.

Connection Issues

Issue	Cause/Solution
ERROR [08001] [IBM] SQL1336N The remote host was not found. SQLSTATE=08001	You are attempting to connect to a database version that is not supported in Toad. Solution: Review the list of supported databases in the Release Notes or Installation Guide.
ERROR [58031] [IBM] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031	Catalog entries have not been imported or defined for the connection. Solution: See Configure DB2 Client Connections for more information to determine the best method for cataloging a database.
"The type initializer for 'IBM.Data.DB2.DB2Connection' threw an exception." or "SUCCESS - unable to allocate an environment handle."	A settings file might be corrupt. Solution: Rename your local settings directory so a new one can be recreated. To rename your local setting directory Exit Toad. Navigate to the following settings directory: Windows Server 2008, Windows 7—C:\Users\username\AppData\ Roaming\Quest Software\ Rename the Toad for DB2 version# folder to "Toad for DB2 OLD". Restart Toad and try to connect. Notes: Make sure you can view hidden folders in Windows Explorer. To navigate to this directory quickly, click the Application Data Directory link in the About dialog (Help \| About).

Issue

Cause/Solution

ERROR [08001] [IBM] SQL1336N The remote host was not found. SQLSTATE=08001

You are attempting to connect to a database version that is not supported in Toad.

Solution:

Review the list of supported databases in the Release Notes or Installation Guide.

ERROR [58031] [IBM] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

Catalog entries have not been imported or defined for the connection.

Solution:

See Configure DB2 Client Connections for more information to determine the best method for cataloging a database.

"The type initializer for 'IBM.Data.DB2.DB2Connection' threw an exception."
or

"SUCCESS - unable to allocate an environment handle."

A settings file might be corrupt.

Solution:

Rename your local settings directory so a new one can be recreated.

To rename your local setting directory

Exit Toad.
Navigate to the following settings directory:
- Windows Server 2008, Windows 7—C:\Users\username\AppData\ Roaming\Quest Software\
Rename the Toad for DB2 version# folder to "Toad for DB2 OLD".
Restart Toad and try to connect.

Notes:

Make sure you can view hidden folders in Windows Explorer.
To navigate to this directory quickly, click the Application Data Directory link in the About dialog (Help | About).

Other Issues

Issue	Cause/Solution
Unable to capture Container Information in DB2 for LUW Multi-Partition Databases	Certain Toad functions require that the DFT_MON_BUFPOOL database manager configuration parameter be set to ON to capture information on containers used in DB2 for LUW databases. Additionally, to capture container information across all partitions in a multi-partition database, the snapshot monitor requires that all database partitions be active. To activate all database partitions (and keep them active), execute the DB2 command ACTIVATE DATABASE real_database_name on the server before connecting Toad to the database. See your IBM DB2 for Linux, Unix, and Windows documentation for more information about this command.

Issue

Cause/Solution

Unable to capture Container Information in DB2 for LUW Multi-Partition Databases

Certain Toad functions require that the DFT_MON_BUFPOOL database manager configuration parameter be set to ON to capture information on containers used in DB2 for LUW databases. Additionally, to capture container information across all partitions in a multi-partition database, the snapshot monitor requires that all database partitions be active. To activate all database partitions (and keep them active), execute the DB2 command ACTIVATE DATABASE real_database_name on the server before connecting Toad to the database. See your IBM DB2 for Linux, Unix, and Windows documentation for more information about this command.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 5.7 - User Guide

Troubleshoot DB2 LUW Issues

Installation Issues

Connection Issues

Other Issues