Issue 1:
No IBM DB2 Client is included with Toad for DB2 version 6.0 and higher (Toad Data Point 3.6 and higher). Previous versions of Toad will still include the client but the clients used in previous installs cannot be used with the newer Toad versions.
Please refer to current
Release Notes under "System Requirements" for more specific information about IBM DB2 Client requirements.
Toad can be installed even if a full DB2 client is not on the system. But on first launch of Toad the following message will be prompted:
ERROR:
"Toad did not find a supported default DB2 client and cannot continue. Please shut down Toad, install a default DB2 client or select a previously installed client as default."
When this occurs, either a full DB2 client is not detected (old ToadC or TACOM DB2 clients are not recognized in Toad) or it is not set as default. Toad for IBM DB2 needs a full DB2 Client 9.7.6 to 10.5.x.
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' (again 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.
Next, also set the default DB2 in the Toad Options screen via Tools menu | Options | Database | DB2 | General | "DB2 Client (...)" drop-down list.
If you need to download an IBM DB2 Client software, go to the '
IBM DB2 Version 11.5 clients and drivers' download site (July 2014, confirmed by Development). This is the DB2 Client software that we know IBM gives out for free. Please choose the
“IBM Data Server Client” (the 5th one down), with a description of “This is the all in one client package and includes all the client tools and libraries available. It includes add-ins for Visual Studio.”
Note: It is recommended that you use your company's own (and possibly licensed) IBM DB2 Client software, if your company already has one.
Issue 2:
In some cases the license for DB2 is not being recognized. The following error could occur after upgrading/installing the DB2 client to be used with Toad. After trying to connect to the database with the full client, Toad may give the following error:
ERROR:
"SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968"
This is not a Toad specific error. It may also occur for the client if trying to connect to the database through command line processor (CLP) through the same client.
When this occurs please verify that the IBM Data server Driver license file version and the installed IBM Data server Driver version are same. There are various reason that there might be a conflict that produces this error. Please refer to DB2 support.
Please contact the Database Administrator (DBA) that is managing the database(s) you are trying to connect to for further assistance on this issue.
This is a licensing issue with the IBM DB2 Client. The DBA will need to enable the server side DB2 licensing logic to enable DB2 connections without the need for any client side DB2 connect licenses.
Alternatively, a DB2 client license file may also be applied on the client side. An example command to run in a Windows Administrator Command Prompt window is shown below:
\bin\db2licm -a (i.e. db2conee.lic, db2ese.lic, etc.)
