IBM Support

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

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Licensing","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21635635