Troubleshooting
Problem
SQL1598N error connecting to mainframe DB2 from IBM Data Server Driver even though DB2 Connect license file exists in the license directory of the install path
Symptom
Per the following Information Center link:
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.apdv.cli.doc/doc/r0024162.html
It is possible to license the IBM Data Server Driver to connect to mainframe DB2 such as DB2 for z/OS, IBM DB2 for IBM i, and DB2 Server for VM and VSE servers by copying one of these files into the installation_path/license directory.
- DB2 Connect Personal Edition: db2conpe.lic
- DB2 Connect Application Server Edition: db2consv_as.lic
- DB2 Connect Enterprise Edition: db2consv_ee.lic
- DB2 Connect Unlimited Edition for System i: db2consv_is.lic
- DB2 Connect Unlimited Edition for System z: db2consv_zs.lic
Even after copying the license file, a test connection may fail with the following error:
SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968
Cause
The license file copied to the license directory is from a different release.
Diagnosing The Problem
Go to the installation_path/bin folder and run db2level. For example it may show the following:
$ db2level
DB21085I Instance "DB2" uses "64" bits and DB2 code release "SQL09076" with
level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23421", and Fix Pack
"6".
Product is installed at "/opt/IBM/dsdriver/V9.7_FP6/dsdriver/.".
View the contents of the license file in a text editor. For example, the file db2consv_zs.lic may show contents such as the following.
License Certificate for 5724-B62 IBM DB2 Connect Unlimited Edition for zSeries, V9.5
In this example, the IBM Data Server Driver installed is from v9.7 but the license file is from v9.5. The license files are not compatible with other releases.
Resolving The Problem
Obtain the DB2 Connect license for the release that matches the db2level and copy it into the installation_path/license directory where the IBM Data Server Driver package is installed.
In order to obtain a DB2 Connect license, please visit the following link:
How do I download my DB2 license from Passport Advantage
http://www-01.ibm.com/support/docview.wss?uid=swg21305417
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21635635