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.)
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.)
1. Go to the link below. Download and install an IBM DB2 client:
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.3
Toad for DB2 6.0 Release notes:
http://dev.toadfordb2.com/releasenotes/latest/ToadDB2RN.htm
2. 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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center