-
Title
Toad for DB2 6.0 and newer, DB2 client requirements. Error: "Toad did not find a default DB2 client" -
Description
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 Data Point can connect to DB2 databases, this would also be the same scenario for Toad Data Point 3.6 and higher as well.)
-
Cause
This applies to version 6.0 and future releases of Toad for DB2. Previous Toad versions are not affected.
Beginning in version 6.0, Toad for DB2 will no longer include or be shipped with an IBM DB2 Client.
Users will need to install an IBM DB2 Client separately, and this may need to be set as "default" within Toad (Options | Database | DB2 ).
(This applies to version 3.6 and future releases of Toad Data Point, as well.)
-
Resolution
1. Go to the link below. Download and install an IBM DB2 client:
IBM Data Server Client Packages Version 10.5 Fix Pack 3:http://www-01.ibm.com/support/docview.wss?uid=swg24036706Download the package noted as:"IBM Data Server Client" (1st item) - Description: This is the all in one client package and includes all the client tools and libraries available. It includes DB2 Control Center, a graphical client tool that can be used to manage DB2 Servers. It also includes add-ins for Visual Studio.NOTE: Please ensure you install it with the highest Administrator Rights (in both the local PC and your network domain). Right-Click the installer file and choose "Run as Administrator". If you do not have it or if you are unsure, please have your IT or Helpdesk people install it for you.
NOTEe: If there are any issues with the download or install of the client itself, please follow up with IBM DB2 Support for further assistance with the client.
System Requirements notes support for the following...
Toad requires that a DB2 Client version 9.7.6 through 10.5.be installed as default.
These DB2 Client versions were tested: 9.7.6, 9.7.9 ,10.1.0, 10.1.2, 10.1.3, 10.5.0, 10.5.2, and 10.5.3Toad for DB2 6.0 Release notes:
http://dev.toadfordb2.com/releasenotes/latest/ToadDB2RN.htm2. Set the default DB2 client in Toad Options:
Once the client is installed locally to Toad, launch Toad. If the message "Did not find a default driver" is still encountered, click OK and in Toad, go to Options | Database | DB2 | General | and set the default DB2 client. The drop down may display previous Toad clients, but do not select these as the default, as this will not be saved and applied.
Only the full IBM DB2 client can be used as default (Data Server Driver Package is supported for Toad for DB2 only, not for Spotlight on DB2). If you have multiple clients installed, then you will need to specify one in the Toad Options. Once this is set, Toad will need to restart. On the next launch, there should be no prompt regarding default client and Toad should be able to connect to the databases as usual.
3. If multiple IBM DB2 Clients are installed in your PC, please set one as 'Default' by going to the Windows Start Menu | All Programs | choose the IBM DB2 client you want to set as 'Default' (do not use clients that came from old Toad versions) | and then use the "Default DB2 and Database Client Interface Selection wizard" to set that particular IBM DB2 Client as Default.